I want a Pivot Table which report how many product 1, 2 and 3 are sold for a selected period. (Side by side as columns P1, P2, P3) Let's say for May 2020.
Is it possible to do that? How?
I want a Pivot Table which report how many product 1, 2 and 3 are sold for a selected period. (Side by side as columns P1, P2, P3) Let's say for May 2020.
Is it possible to do that? How?
Pivot table example in attached.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
1) On this file "product sold" is defined with the column name as "serial no"
I tried to put "serial no" into the columns field and It looks like It doesn't work.
How can I do that?
2) When I try to update the Pivot Table after adding data I get this error; Cannot open Pivot Table Source file.
Why? How can I fix it?
Working with your data would make more sense if you populated it with some data. Hard to figure out what is wrong when all you have is field names and no data to test.
All the data you need to accomplish this is there.
Serial No shows different products (Product 1 (P1), Product 2 (P2) etc.) also shows It is sold on the date in the same row (Date Column).
The columns D:S in the Sheet Report contains quantitive data. (Amount ($) and KDV (VAT) Rate) for the Products Sold.
All the other data is non-quantitive data.
Last edited by zanshin777; 11-24-2021 at 01:03 PM.
Good Luck finding a solution. I can offer no further help for this issue.
Thank you very much for the answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks