Hierarchy level Aggregaration

[imrasyed]

Hi Experts,

I have a Hierarchy with Territory,Division,Product Line,Business Unit.

I want to get the aggregated total at each Level.

For Example:

If I go to product Line it shd give me total of product lines ignoring territory.

can any one let me know how i can achieve?

[agni_gold]

Hi ,

Are you using pivot table ?

[satishkurra]

See if this helps. I'm attaching the same app built in both QV and QS

The 2nd and 3rd expression gives you the TOTAL and SUB TOTAL by Product ignoring Product Name

ALso refer this link if you need to display totals at the bottom

https://community.qlik.com/thread/200383

[imrasyed]

Yes Agnivesh

[imrasyed]

This is only for one level.

If i have Multiple levels like Business Unit and when I drop down the hierarachy to Product Line level it should display the total value ignoring the first level of hierarchy