Thread: [Solved] Tracking Expenses
View Single Post
 
Old 10-11-2024, 03:34 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by Karen615 View Post
In both report tabs, is it possible to format the 3-character state to automatically spelling it out?
3-character state?
I don't see a 3-character anything in your data; I see 2-character locations, but I don't don't know what they're short for. you would need a separate table of 3-character states and their full spelling.

Quote:
Originally Posted by Karen615 View Post
Also, is it possible to format each total row to automatically fill with a light gray color?
See attached where there's a new table style that I've used for both your pivots.
Reply With Quote