Aggregate dimension

[#1]

Hi all,

I'm trying to get the total of the dimension(Peer) to show in the chart no matter what value in the second dimension has been selected.

In this example I want to have the total shown for the Ref1 dimension shown as the Peer Performance no matter what Ref2 is selected.

If I select a single Ref2 (as show above here) value then I want the total of 107 to show in the Peer Performance measure, no matter what Ref2 I have selected. Ref1 is the parent, which can have 1 or many Ref2 values.

I have used a number of different Sum(Aggr) or Aggr(Sum)...total etc.... variations but nothing seems to be working.

Any ideas would be greatly appreciated.

Many thanks.

[Mark_Little · Accepted solution]

Hi,

Could you share a sample QVW?

I would be Looking at something like

AGGR(SUM({1}Value),PEER)

Mark

[PrashantSangle]

Hi,

dont required any aggr()

just try with

sum({1}Value)

Regards

[Gysbert_Wassenaar]

Try Sum({<Ref2=>} TOTAL <Ref1> Peer)

Or Sum({<Ref2=>} TOTAL <Ref1> Days) if you want to see 107 as a result.