Hai
I using pivot table calculate the total budget expenses for the whole year and at the same I would to know total as at for the period (using Filter or Slicer). Can Pivot table show me 2 different column of amount 1) for period as at (Example period 6) and the same time whole year budget which not reflect on the filter or slicer. I try not using Power Pivot because only few computer have that program.
Thank you
I using pivot table calculate the total budget expenses for the whole year and at the same I would to know total as at for the period (using Filter or Slicer). Can Pivot table show me 2 different column of amount 1) for period as at (Example period 6) and the same time whole year budget which not reflect on the filter or slicer. I try not using Power Pivot because only few computer have that program.
Thank you