• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table show value as no calculation

Could anyone assist?

I have a pivot table and source data with percentage already displayed.
When i insert a pivot table it sums up the percentage and there is no other option to display value as
upload_2018-8-30_13-1-39.png
upload_2018-8-30_13-2-15.png
 

Attachments

  • question.xlsx
    144.6 KB · Views: 5
leonardtan
Did You test 'all possible settings'?
With which settings there should be needed options?
What kind of values there would be?
> I test something ... and now it looks like this. <
 

Attachments

  • question.xlsx
    149.5 KB · Views: 7
leonardtan
Did You test 'all possible settings'?
With which settings there should be needed options?
What kind of values there would be?
> I test something ... and now it looks like this. <

pivot table setting to display percentage as per data tab on worksheet VD_Bev from excel row H 201: J297 in this format
upload_2018-9-2_13-7-12.png
 
leonardtan
You asked something different...
Something that You could see in my sent file.
There are values to show as in Your original file.
 
I was just using the word pivot table as I thought that was the right terminology, but possibly not! My starting point is having 3 columns: Name, Value and Month. Any help would be appreciated! Plex Kodi Lucky Patcher
 
kismpd
If You have a new case then You should open a new case.
Why Your three last words are links to somewhere?
How would those connect to this or any case?
 
Back
Top