How to make my 2 Table ( long expression ) combine into 1 ?

[paulyeo11]

Hi All

I have 2 table , one table is display sales up , and another table is for display sales down.

Because i want to make my table easy maintenance. I want to make this table into 1 table. and

using button to trigger to display the sales up or sales down.

Can some one share with how to do it ?

in my recent post , i have same questions. Some one share with me using button. and create variable , it work fine. But this time my table expression is very long.

Enclosed my QVW which have 2 Tab , will show you the 2 Table .

Paul

[paulyeo11]

My QV Doc

[uacg0009]

Hi Yeo,

I think it's not too hard to make it, you just need to add a variable into the condition, then I think that's ok.

For example, you have a variable vShow_Sales_Up, and you have a button to change it between 1 and 0.

And when the vShow = 1, in the table, you just make condition of the dimension and expressions about sales up to show, and also for sales down.

Hope it's helpful.

Thanks

Aiolos