Hi Exceler,
How can I add column to make calculation in pivot table? for example in the figure, How can i dived total upon unit?
Please Help ,,,
Hi Exceler,
How can I add column to make calculation in pivot table? for example in the figure, How can i dived total upon unit?
Please Help ,,,
Drag once more Units in to Value then right click on newly created column go to show value as and you will get too many option but you must select % parent row total.
Hope it will help you![]()
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Hi,
You actually need to show values as the % of column total.
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks