Total Qualifier

[Anonymous]

Hi all!

Could anyone please explain me the meaning of the expression below??

sum(total<A,B,C,D>

if(DataDate=(vMaxDate),

aggr(WHStock,A,B,C,D,WHStock)))

Note: where A,B,C,D are the fields.

[Anil_Babu_Samineni]

What is the WHStock?

Exp - Here When DateDate = vMaxDate then aggregate to each value by A,B,C,D and Summation to the A,B,C,D in total

[Anonymous]

Hi Anil

WHStock is a measure.

[tresesco]

If your query is more on total qualifier, then have a look here What does the TOTAL qualifier do? It's impact would mainly depend on the dimensions you use in the chart.

[shiveshsingh]

This will give you total but based on A,B,C,D.

[Anil_Babu_Samineni]

Have you got solution? Don't thread alone do something like Helpful and Correct answers ?