SOLVED
Home

Listing field values in a pivot table

Andrea_Johnson
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
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

Thanks. I'll try that.

AJ
Thanks again! Tabular form gave me what I needed.

AJ

@Andrea_Johnson 

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