

February 1, 2019

Hi,
i am not sure if this topic should be in PQ forum or Power Pivot.
i have pivot table like in screen attached.
there are all Topologies and tiers and Total costs calculated.
This is ok.
The problem is that i have in "Expected result" worksheet in column "Total Cost per Topology" costs for whole topology (not divided per tier)
And i have to sum up all costs together (Total Cost per Topology + Total cost for Topology and Tiers).
I do not think that it is possible in one table so i thought that i can build separate table.
It is possible to do this in PQ?
Or maybe there is other solution?
Please help,
Jacek


July 16, 2010

Hi Jacek,
Please see attached. I think it's time for you to take a Power Query course. These aren't difficult questions and are things you should be able to easily work out for yourself if you did a bit of training.
Mynda
1 Guest(s)
