I have report that is sub totalled for two dimensions.
Dim1 Dim2 Metric1 Mertic2 Metric3(Metric1/Metric2)
abc efg 100 20 5
dffd vew 200 10 20
Totals 300 30 10(should be 25,col total)
How do i get the correct value in pivot for the calculated (metric col).I have tried unchecking report based totals didn't work.
Did you change aggregation rule from default to Sum?