Dimension from many excel sheets

[ncjam20]

Hi, 

I'm facing an issue that I don't understand while building a Bar Chart. I am working with a database of Menus ordered during a cruise. I have 6 sheets like the one one in the screenshot, representing 6 days of the week.

To simplify, they are 30 different menus, the sames each day. 

For my bar chart, I've put as dimension =MenuTitleDinerDay1,

and for Measures: =Count(MenuTitleDinerDay1)+Count(MenuTitleDinerDay2)+Count(MenuTitleDinerDay3)+Count(MenuTitleDinerDay4)+Count(MenuTitleDinerDay5)+Count(MenuTitleDinerDay6)

I have a good looking result (Menus are sorted from the most ordered, and the total correspond to the total of orders), but I wanted to check and changed the dimension as =MenuTitleDinerDay2 and the bar chart changed: the first menus were different, but the total was still good. Basically, everytime I change the dimension from a day to another, the order of the menus change (and I thought it would always be the same as the dimension of day 1 is the same in day 2 for me..)

I don't know if I'm very clear 😕 If someone has any ideas on how to fix that, I would be very pleased!

Regards,

Nicolas

[Rao_007]

It is better to use Alternate state