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
Hi Jacek,
I'm confused. Your source data doesn't have the 'Total Cost per Topology', but it's in your 'Expected Result'. Is there a second source data somewhere that contains the 'Total Cost per Topology'?
Mynda
hi Mynda,
thank you.
yes Total Cost per Topology is from second table.
I have just put this into my expected result woeksheet.
Best,
Jacek
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
Thank you Mynda,
all is working fine!
Best,
Jacek
