Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
I think this would be the best place to look
Nice article but my question still remains. if both works same then what is use of TOTAL here?
The article should explain that there is a difference when you are using the expression in a chart with dimensions.
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...
Check out how Sum({1} TOTAL Sales) gives me 30 for both rows, whereas Sum({1} Sales) give 10 and 20
You are too kind, Sunny. It's explained quite well in the blog post you linked to... Including sample.
I guess you are right
Thank you Sunny, stefan