Community,
My data is formatted per my example screenshot below.
Is it best to pivot each location into rows, or is there a benefit to maintaining columns for rows?
I will need a total number, and then drill down numbers (I.e. Total Net Profit = 30 > Drill Down > Omaha Net Profit = 10)