Apr 28 2022 09:10 AM
Hello,
Thank you in advance for any help.
My problem is with regards to the PivotTable Analyze "Filter". I have a sheet with multiple tables on it. (ex. Table2022, Table 2021, Table 2019) per client. When I export it to the SourceData, everything looks fine but when I started doing the PivotTable, I can see the problem in the filter section.
Each client is under one name in the filter. Except for two clients whose tables are separated in the filter tab.
Client 1 (contains Table 2022, Table 2021, Table2019)
Client 2 (contains Table 2022)
Client 2 (contains Table 2021)
Client 3 (contains Table 2022)
Client 3 (contains Table 2021)
Client 4 (contains Table 2022, Table 2021, Table2019)
Client 5 (contains Table 2022, Table 2021, Table2019)
I tried deleting the sheets and re-doing them but the results are the same. I added new clients and it shows Client 6 (which contains Table 2022, Table 2021, Table2019). I don't see any errors so I am not sure what I am doing wrong with the 2 clients.
Any help is greatly appreciated.
thank you