Hello,
I have a pivot table of GL Accounts against monthly spend.
If a GL account has no spend (and is therefore not in the source data) then there is no corresponding row in the pivot table - which is perceived by my users as an error.
What is the best way to display all GL accounts whether or not they have spend data? I have a full list of GL accounts that I need to have showing - is there a way of incorporating this data?
Thanks,
Poiu
I have a pivot table of GL Accounts against monthly spend.
If a GL account has no spend (and is therefore not in the source data) then there is no corresponding row in the pivot table - which is perceived by my users as an error.
What is the best way to display all GL accounts whether or not they have spend data? I have a full list of GL accounts that I need to have showing - is there a way of incorporating this data?
Thanks,
Poiu