Hi there,

I am having a difficult time attempting to create a data column that shows as a % of the subtotal rather than the total.

To clarify, in the design I have:

Page: State
Row: City, Event(s) Occurring
Data: Counting the number of events that occurred and getting the % of that occurrence to the subtotal not the total.

For instance if I have:

Days %
Seattle 10 rainy days A
30 sunny days B
Seattle Total Days 40 total days

Tacoma 15 rainy days
40 sunny days
Tacoma Total Days 55 days

Grand Total Days 95 days

I would want A to be 10/40 to show 25% rather than 10/95 to show closer to 10%. I try to use the "show data as: column" or "base field" but nothing seems to be working. I'd appreciate whatever help I could get.

Thanks!