Listing field values in a pivot table

New Contributor

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?

4 Replies



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

Thanks. I'll try that.

Thanks again! Tabular form gave me what I needed.



I'm glad I was able to help

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies