Oct 25th, 2010, 11:26 AM
#1
Thread Starter
Fanatic Member
sum percent in Pivot table
Hi
I must to build a Pivot Table where there are a column is perecent of others 2 columns, when Build PT (pivottable) , It must to do percent from total example
DIFFERENCE is SPENT minus QTD, and PERCENT is DIFFERENCE/QTD
QTD SPENT DIFFERENCE PERCENT
20 10 -10 -50%
40 60 20 +50%
30 45 15 +50%
When I built PT the sum show
90 130 40 50%
I would like show
90 130 40 40/90 ===> 44,44%
Is there some way to do it ?
Oct 25th, 2010, 01:57 PM
#2
Re: sum percent in Pivot table
Attached Files
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread " Resolved", if the query is solved
MyGear :
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
Oct 26th, 2010, 04:59 AM
#3
Thread Starter
Fanatic Member
Re: sum percent in Pivot table
Thank
But I must show sum of percent like sample in cell E5
Attached Files
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules
Click Here to Expand Forum to Full Width