Skip to Content
0
Jan 13, 2023 at 11:04 AM

Calculate Count of dimensions

162 Views

Hello Experts,

I have the requirement to calculate the number of deputyships for the Entity Dimension as shown below in the screenshot.

image.png

I have created data action as the below to derive the count but that not working as expected its only working on the lowest leaf member while the deputyship entities are at the second level.

image.png

Any suggestion on how I can achieve that requirement?

Thanks.

Attachments

image.png (51.7 kB)
image.png (31.3 kB)