Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. member [RefIDCount] as distinctCount([Incident Details].[Process Safety Classification].&[Tier 1])
  2.  
  3. select
  4. {
  5. [RefIDCount]
  6. } on columns,
  7. {
  8. DESCENDANTS(
  9. [Reporting Hierarchies].[Hierarchy].[Reporting Category].&[49]
  10. -- #RepCat#
  11. )
  12. } on rows
  13. FROM [Monthly Stats]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement