Oct 15 2019 04:25 PM
I'm trying to build a pivot table that will capture the amount of tax collected at each tax rate per month. The fields I'm taking from the source table are: Month, Tax Rates, and Tax Amount. How do I make the pivot table list the values that are in the Tax Rate field without performing any calculations?
Oct 15 2019 04:57 PM
SolutionHi
You can simply drag the Month field to the Rows drop area
Then Drag the Tax rate under Month also in the Rows Drop area
The Drag the Amount to the Values area
To split the Month & Tax Rate into 2 separate Columns:
You go to the Design Tab >> Report Layout >> Show in Tabular Form
Hope that Helps
Nabil Mourad
Oct 15 2019 06:28 PM
Oct 15 2019 06:35 PM
I'm glad I was able to help
Oct 15 2019 04:57 PM
SolutionHi
You can simply drag the Month field to the Rows drop area
Then Drag the Tax rate under Month also in the Rows Drop area
The Drag the Amount to the Values area
To split the Month & Tax Rate into 2 separate Columns:
You go to the Design Tab >> Report Layout >> Show in Tabular Form
Hope that Helps
Nabil Mourad