Total Keyword in Set Analysis

[#1]

Hello All,

What is a use of tatal keyword in set analysis?

Thanks in advance..

[tresesco · Accepted solution]

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

[jonathandienst]

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)

[jagan]

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.

[#5]

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)