Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
What is a use of tatal keyword in set analysis?
Thanks in advance..
Total keyword is not specific to set analysis. In short it helps bypass dimensions in a chart. For better understanding read John's explanation here: Keywords : TOTAL, ALL & DISTINCT
Total keyword is not specific to set analysis. In short it helps bypass dimensions in a chart. For better understanding read John's explanation here: Keywords : TOTAL, ALL & DISTINCT
The total keyword is not part of set analysis. In a table or chart, it causes the expression to be evaluated without regard to the table or chart dimensions (ie at a total level) - for example:
Sum(TOTAL Sales)
Set analysis is a way of filtering data - eg to sum sales for the North region:
Sum({<Region = {North}>} Sales)
Combined - sum for North region without regard to dimenions:
Sum({<Region = {North}>} TOTAL Sales)
Hi,
TOTAL keyword will ignore the dimensions in the chart. For example if you have sample data like
Branch, Sales
1, 100
1, 200
2, 100
2, 200
Now in chart if you use Branch as Dimension and use below expression
=Sum(Sales)
Now you will get
Branch, Sales
1, 300
2, 300
The same way if you use TOTAL in expression like Sum(TOTAL Sales) then the output would be
Branch, Sales
1, 600
2, 600
TOTAL will ignore the dimension (Branch) and it will sum all sales values and display against each dimension value.
Hope this helps you.
Regards,
Jagan.
Hi,
If you want to ignore the dimension and not the selection then you want to use the TOTAL keyword, e.g., sum(total<Date> Sales)