Hierarchial calculations Level4/level3

[former_member199543]

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.

[jyothirmayee_s]

Hi,

Well, there is an option to filter on the Date.Fiscal hierarchy to just show from Level 0 to Level 4.

Define Depth of the hierarchy and apply filter on that variable

@Datedepth=[Date Depth].depth

Apply filter on Datedepth variable = 0,1,2,3, and 4.

but if you still need to show the Level 4 in detail after the drill down then

Use the same Datdepth formula as

If Datedepth <> 5 then display percentage.

Let me know how it works.

Thanks,

Jothi