try the attached workbook.
I have used normal sales in your rows shelf then created one filter for the worksheet:
Then another field for colour:
few things are not correct :
data for First class and First class sameday is showing same sales...that is not correct
and Total should display combined sales but the $ amount is showing at 700K which is not correct:
am i missing any thing here
1 of 1 people found this helpful
Update the show filter to this:
if [Show] = [Ship Mode]
elseif [Show] = 'Total' then 'True'
ELSEIF [Show] = 'First Class Same Day' and ([Ship Mode] = 'First Class' or [Ship Mode] = 'Same Day') then 'True'
This helped . Thank you Mavis.