Forum Discussion
Solved
Creating Chart from multiple Pivot tables
I have a set of data as uploaded. I need to have distinct count from suppliers within a specific period. The details are mentioned in the excel data itself. Can someone please help me? Thanks ...
I didn't sort months/periods in previous variant, corrected in attached.
SergeiBaklan Hi,
I think I got it. I just selected the months I wanted and it gives me th result.
Now how can i do this for quarterly basis?
Secondly, is there any way to show the Grand total in Bar chart? i am not able to do it.
See the file.
Thank you
I didn't sort months/periods in previous variant, corrected in attached.