Hi
I am stuck with requirement to create Pivot table with below details:
Dimension1 - Operator
Dimension2-ID
Dimension3-Columns-Month
Measure - rangemin(count(ID)-Rangesum(before(Column(1), 1, NoOfColumns(TOTAL))),count(apiid)
If i create a pivot table with all above parameters with dimension2(ID) as well it works well. However i want to create a table without dimension2(ID) but the total of table should be based on id level and not the total of dimension1. For instance (Expected output) :
Dimension 1 - Operator
Dimension2-Columns-Month
Measure - rangemin(count(ID)-Rangesum(before(Column(1), 1, NoOfColumns(TOTAL))),count(apiid). Tried using sum and aggr function but it doesnt work.
To be precise, it is breaking with this logic Rangesum(before(Column(1), 1, NoOfColumns(TOTAL)). In this logic, we are trying to calculate the previous month total derived by using the measure expression.
Any help in this case will be highly appreciated since i am banging my head to resolve this for a month now.
