I got a requirement to display total of only two levels and I was having 4 levels in dimension variable put in Column of the table.
Column/Row Total simply adds all columns/Rows.
To achieve the target, I have used Calculated fields.
I am using Superstore dataset to recreate the problem, and its solution.
I have data in tabular format as:
Problem is to display a column named “TOTAL” displaying total profit in year 2012 and 2014.
Then, what we need to do is to break existing 4 levels into 4 different measures and 5th will be Total. Create 5 calculated fields – 4 for 4 levels of variable and 1 for TOTAL.
In similar way, create 2012, 2013, 2014 calculated field.
and in TOTAL put + – summation of these two calculated fields
Now drag measure names to filter and select the 5 measures and again drag measure names to columns and measure values to Text.
In the similar way we can customize row total as well.