Hi!
I created a pivot table and had to manually add columns to calculate growth%. How do I get both the PIVOT TABLE and the added columns to filter together?
eg. column A-D is pivot data then F & H are my added columns with formulas.
Thanks!
Hi!
I created a pivot table and had to manually add columns to calculate growth%. How do I get both the PIVOT TABLE and the added columns to filter together?
eg. column A-D is pivot data then F & H are my added columns with formulas.
Thanks!
Last edited by Scizzy; 04-22-2020 at 11:31 AM.
Administrative note
Welcome to the forum
in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?
Please take a moment to read it and attach a sheet accordingly.
Thanks you for helping us help you
Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks
Done I think
Tried but no matter how much I reduce it keeps failing on upload. I can't make it 1000KB
You can also zip the file if needed
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks