Skip to Content
0
Jun 14, 2016 at 12:37 PM

Hierarchial calculations Level4/level3

17 Views

Hi all

I got a question regarding calculations, maybe someone knows : i would like to add one column in which i can see Month being divided by Quarter (see printscreen),

I managed to get this with: =sum(sales;{Ancestor(Hierarchy.Month)})/sum(sales;{Acestor(Hierarchy.Quarter)}) ,

It does the trick , but if i expand Month then the calculations continues and shows the same number for all weeks/days etc, which i would like to hide. I tried to use Rules etc, but without success.

Any idea? The result, which i would like to achieve can be seen on second printscreen.

Attachments

graph.JPG (60.9 kB)
Untitled.png (26.3 kB)