Here we got two pivot tables with different drill down groups, first table drill down is from profit center table and second one is from equipment table. The issue i am facing here is, the last metric(Total equipment) is showing wrong values for the field values but total value is correct. I tried to move profit center table, and connected to equipment table, in this case i am only getting last metric values right not the reaming metrics. I am suspecting that some ware in the fact table(WOsummary) i am doing my calculations wrong , means not aggregating values with profit center drill down group. Can anyone provide me solution for my problem. Please find the attached QVW.
Solved! Go to Solution.
FYI, the last metric in first pivot table is showing total correct but not east and west values. This is what my actual problem. sunindia please spend some time in this.
Try AGRR() in your expression
modify your expression like
Expected output(total) is 206 only it is matching with below table, but values for east and west are wrong i am not sure about the values because it is a limited load.
Thanks a lot Kavita, a slight change i took following exp
i have changed dimension for aggregation.