How to cycle between $ figures and units in bar chart?

[#1]

I have a bar chart showing Sales Dollars and Purchases Dollars (expressions) by Month (Dimension). I would like to have a way for the user to choose to see Sales Units and Purchase Units instead of the dollar figures. How can I achieve that? I looked into grouping expressions but I would not like to have 2 cyclic buttons (one for sales and one for purchases). I would like to have one single button to change all expressions in the chart.

Thanks for the help!

[danieloberbilli]

You could use 2 buttons and a variable to show one  expression at a time.

Please find .qvw attached

[danieloberbilli · Accepted solution]

sorry - i didnt read it properly.

If you would like one button only you could use 1/0 in the variable and the action on one button with

=not(vShowExpression)

PFA

[buzzy996]

may be,by writing expression tis way ..u can achieve this.

on ur expression: if(u select from list box/button dollars then ur expression should calculate sum(sales) else count(sales unites))

[MarcoWedel]

Hi,

instead of creating different expressions for sales and purchases you could create one expression for both and an additional calculated dimension like

valuelist('sales','purchases')

to distinct between both.

Your expression could look like

Pick(Match(valuelist('sales','purchases'),'sales','purchases'),

        Expression1,

        Expression2

)

If you do this seperately for dollars and unit count, you could switch between both with only one expression group.

hope this helps

regards

Marco