Discussion Board for collaboration on QlikView Layout & Visualizations.
Below is the sample data which i need to convert to pivot in expected format. Have attached both the details. How can we achieve this ?
Any help will be appreciated.
Go to Solution.
It seems that Totals are the avg for the region... Something like this?
=If(Dimensionality() = 2, Sum(Value), Avg(Value))
How are the totals getting calculated?
It looked that your totals are the average, right? Then you could use:
or if you need to sum the value on the city-level with an aggr-function, like: