Listing field values in a pivot table

[Andrea_Johnson]

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?

[#2 · Accepted solution]

@Andrea_Johnson 

Hi

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

[#3]

Thanks. I'll try that.

AJ

[#4]

Thanks again! Tabular form gave me what I needed.

AJ

[#5]

@Andrea_Johnson 

I'm glad I was able to help