Need the percentage match with the Overseas report for All offices, and All Date/Week Range.
Since the dashboard will need to be dynamic (meaning, when people filter by Date/Wk or by Office, they will see the data updated accordingly), we were wondering if you could please let me know if there’s a way we can ensure that the data will still reflect the OverSeas report if we filter it down.
For instance, when we filtered by 1/31/21 which is Feb Wk 1 for All offices, the pivot looks like this:
However, the Total # of unit and percentage don’t match what’s on the Overseas report:
Another example is that we also need to filter it by office (and sometimes by different week/weeks). In this case, we selected Feb Wk 1 and Wk 2 for Hong Kong, and it looks like this:
However, the Total # of unit and percentage don’t match with what’s on the OS report for Hong Kong:
Bookmarks