What's the difference between TOTAL and ALL options in expressions?

[jblomqvist]

Hi all,

What's the difference between TOTAL and ALL options in expressions?

Has anyone got some illustrated examples?

[swuehl]

As far as I remember, ALL is a depricated keyword (still working, but should not be used in new developments) and equivalent to

TOTAL {1}

i.e. disregard all user selections, all dimensions within the aggregation.

[sunny_talwar]

Although All might still be working, but I have heard that it may be discontinued from future versions.

All -> TOTAL and {1}

Total -> TOTAL

So basically if you wanted to create an expression where it was Total and also doesn't change based on selection, you can use All

Sum(ALL Sales) = Sum(TOTAL {1} Sales)

[mayankraoka]

Hi John,

Total & ALLs

sum(All Sales) returns aggregated sales irrespective of any dimension and any selection

sum(Sales)/sum(total Sales) returns the share within the selection

sum(Sales)/sum(total <Month> Sales) returns the share within the selection for each

Month

sum(Sales)/sum(total <Month,Grp> Sales) returns the share within the selection for

each Month and Grp

sum(Sales)/sum(total <Qtr,Month,Week> Sales) possible syntax for use with a time

drill-down group

sum({1} total Sales) returns sales within the entire document

Regards,

Mayank

[MarcoWedel]

maybe also helpful:

What does the TOTAL qualifier do?

The Aggregation Scope

regards

Marco