Total columns

[mcmanus_peter]

Hi,

How would i go about putting the total of columns at the bottom of the table and total of rows at the right hand side.

Also I need to put a variance at the bottom of a table, then subtract a total from this. Unsure about the best and easiest approach.

[y_grynechko]

Hey, unfortunately qlik sense is not there to replace the excel but you can work around it.

For example you can add additional value to your dimension called 'Total' which has all of the values under it. 

[JordyWegman]

Hi Peter,

You don't want it that way, it's not like Excel. You can try the functions:

NoOfRows()

NoOfColumns()

Variance depends on what you see as variance, but you can give the formula. Use for all three of these a KPI object and you will have your result.

Jordy

Climber