Hi,
i am not good with pivot or PQ queries and have question about issue which i am struggling right now.
Screenshot_13.png
Screenshot_14.png
And these tables could be joined with fields VolumeKey and KeyVolume somehow.
I build pivot table and summing up all KeyVolumes disk costs there.
It would be ok but i have 2 conditions to do:
If Tier group = "ZX" multiply cost by "Additional Servers" number
If MountPointName = "/usr/sap", then multiply by 2
if i would join these tables somehow or build pivot table with calcualted fields maybe it could work?
As you can see there is Total cost for GeneralID and i have problem how to calculate it.
This is not straighforward but with conditions.
Please help with my example attached,
Goal is to combine these two tables, create calculated fields based on provided conditions and calculate costs per each Tier Group and Total.
Best,
Jacek
Bookmarks