Forum

Ok now I have a new problem 🙂 The value from the new dummy PivotTable helps automatically categorize the data in the source table. But for my chart...

Ingenious! Thank you!

I had changed the 'Number of items to retain per field' setting to None, yes. I even copied the source to a new file and made a new Pivot. Didn't help...

Hi Lynda - many many thanks for the swift response. I'm not sure if I-explained / you-read properly. I don't want the 'last n weeks'. What I want -...