YTD stacked bar

[#1]

Hi,

I am creating a bar chart with no dimension.

So i have 3 expressions to make 3 bars:

• Sales for current month
• Year to date sales.
• Last year to date sales

Next, i'd like to make them as stack-bar, so i can have segments of says- product type in each bar.

But i'm stuck here...

[Gysbert_Wassenaar · Accepted solution]

See attached qvw. I use a valuelist to create a calculate dimension with a value for the three different expression. The actual expression is a nested if that uses the value from the valuelist. The Product dimension is used the stack segments.

edit: updated the qvw to add a chart with an ascending sort on the second dimension to sort the stack.

[#3]

Hi Gysbert ,

Thanks ! smart solution.

Just another question, is there a way i could sort the stack ascending?