Total vs {1} Total

[#1]

hi,

I used following statements.

1. Sum({1} TOTAL Sales) - Take sum of sales & doesn't change if you select any filter ( city, region, year etc)

2. Sum({1} Sales) - Take sum of sales & doesn't change if you select any filter ( city, region, year etc)

if both works same then what is use of TOTAL here?

could anyone explain me in what scenario we should use it?

[sunny_talwar]

I think this would be the best place to look

The Aggregation Scope

[#3]

Nice article but my question still remains. if both works same then what is use of TOTAL here?

[swuehl]

The article should explain that there is a difference when you are using the expression in a chart with dimensions.

[sunny_talwar]

If they both are getting used in a text box, then having a total doesn't make any difference, but in a straight table or pivot table, the two expression will give different results..... Sample to follow...

[sunny_talwar]

Check out how Sum({1} TOTAL Sales) gives me 30 for both rows, whereas Sum({1} Sales) give 10 and 20

[swuehl]

You are too kind, Sunny. It's explained quite well in the blog post you linked to... Including sample.

[sunny_talwar]

I guess you are right

[#9]

Thank you Sunny, stefan