Can't figure out how to set the % on this pivot table. Essentially column I is a % based on Column H. It is calculating the % off of the Grand Total where I need it to show the % breakdown taking into Account Column A and Column B.
The % in Column J is what I want calculated as part of the pivot in Column I.
Screenshot 2024-03-05 161047.jpg
If you want to display values in column I as a %, just open the fields list and choose the sum of POLine_lineAmt2, and adjust its settings format to be a percentage.
But if you want to include column J in the pivot table itself, then add a calculated column and name it what you want, and in its field add the columns you want by hit insert and use the required operation to fit what you want.
If you uploaded the file we can help more.
Thank,
Mohamed GadAllah
Welcome to the forum.
As you continue using the forum you will notice that with a file attached you will receive the help that you need much faster.
Mohamed the issue Column I is calculating the the % off of the Grand Total of Column H. I need to show Column H as a % in Column I however I need the % to not be of the grand total but the % of the Sum of Each Vendor for Each Inventory Id.
yes I know but the file has 30K lines and confidential data.
Small desensitize file?
In the fields list, when you click POLine_lineAmt (column H) open its properties or settings, and check the available options if it has what you want.
If you did not find it, you just add a calculated column (even if it is duplicated) and just change its contents or its calculations operations.
If it is still not available, just do it in several steps till you get the item you are after.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks