Hi All,
I have a Pivot table that the value and column will change when the filter change.
For example, if i choose certain filter it will should the below Pivot table:
Name SGDUSDTotal
If i choose other value for the filter, it may only show three columns.
For Example:
Name SGDTotal
I have another sheet which i will like to capture the Value in the Total Column of the Pivot table.
Can i know how can i do that?
Thanks in advance.
I have a Pivot table that the value and column will change when the filter change.
For example, if i choose certain filter it will should the below Pivot table:
Name SGDUSDTotal
If i choose other value for the filter, it may only show three columns.
For Example:
Name SGDTotal
I have another sheet which i will like to capture the Value in the Total Column of the Pivot table.
Can i know how can i do that?
Thanks in advance.