Nov 18 2019 02:34 AM
Hi There,
I have created a pivot table using data pulled from a data model consisting of two different tables. It's basically a report that list customer names and their sales for different products. I have multiple data filter in the table (customer territory, customer type, etc), one item under rows (customer name), and various fields under columns and data.
I have added another column that ranks the sales data used in the pivot table for each row (customer name), and everything works as expected. However I want to see the customer name and the customer ID number in the report when looking at their sales data and ranking. As soon as I add another row to the report so that I can see the customer name and number, all the rankings change from their correct values to 1.
I have tried moving the customer number field to various places in the report, but I can't figure this one out?
Please assist.
Nov 18 2019 02:59 AM
Jan 24 2022 07:54 AM