Hi,
I'm "new" on here... I say "new" 'cause I have found a lot of useful information on here in the past, without actually being registered...
This time, I have run into a problem though that I simply cannot wrap my head around or better said, I simply cannot get the wished result, even after looking through several Forums, discussions and other tips and tricks.
So.... I decided to register and see if someone can help me with my problem or if there is others with the same issue?!
A BIG Hello to all and an even BIGGER THANK YOU to all those that have provided such good help and I never got a chance to say thanks
My problem;
I need to buid a pivot with % (showing the left over or usage of something). All in all that's ok, however, when it comes to the "totals" the pivot is taking the SUM % of the sub %, instead of actually calculating the % figures shown in the total again...
I have treid using a calcualted field... but for some reason that looks even worse in the end I created a column that calculates the % and then added it like that, but that is still not accurate in what I'm trying to demonstrate.
Has anyone got a clever idea on how I could maybe get excel to do my bidding, using a trick or a workaround (adding more columns in the data etc...)?
I have attached the file to show what I mean
MyProblem.xlsx
(not to mention that the office I have to use here is "german"... does not make life simpler but it's fine)
Bookmarks