Hi, Please Answer !!!

[ramcena306]

I have 2 tables, 1 for Sales, 2 table for Purchase. On top i have created 2 buttons-- Show Sales, Show Purchase.

When i click on Show Sales Button Prechase table will Disappear , and

When i click on Show Purchase Button Sales table will Disappear. How can i achieve this ????

[prat1507]

You can use conditional statement in layout for the tables.

Regards
Pratyush

[stabben23]

Hi,

something like this

[Peter_Cammaert · Accepted solution]

1. Create a new variable. Let's call it vShowSalesOrPurchase
2. Create a Sales button and add an action that sets vShowSalesOrPurchase to 1
3. Create a Purchase button and add an action that sets vShowSalesOrPurchase to 2
4. Create a Sales table/chart and in Layout set the conditional show expression to vShowSalesOrPurchase = 1
5. Create a Purchase table/chart and in Layout set the conditional show expression to vShowSalesOrPurchase = 2

Best,

Peter

[ramcena306]

Hi @Peter, Thank You. It Helps !!