Hi,
This is probably a brain teaser and Please help me with simple logic.
I have 2 scenarios so that, if you can suggest me solution for any one of the scenario my problem will be solved. The help is appreciated.
Scenario 1:
Here is the table.
| Merchant | Phone-sales_Count | Store-sales_Count | Online-sales_Count |
|---|
| Best Buy | 3000 | 2000 | 1000 |
| Apple | 2300 | 3400 | 3200 |
| Walmart | 9800 | 5600 | 4300 |
| Costco | 1600 | 1400 | 1900 |
Now I am plotted a Stacked Bar Chart with below parameters:
Dimension: Merchant_Name
Measures: Phone-sales_Count, Store-sales_Count, Online-sales_Count
Now I want to have a Filters which actually filters between the measures ( Phone-sales_Count, Store-sales_Count, Online-sales_Count), so that the stacked chart will show the selected measure data only.
| Filter_Sales |
|---|
| Phone-sales_Count |
| Store-sales_Count |
| Online-sales_Count |
Please help me How can I do that.
Scenario 2:
I changed the table and data format to below as the filter does not work for me.
But this time, the filter worked but the stacked chart is not working because I can select only count.
| Merchant | Type_of_Sale | Count |
|---|
| Best Buy | Phone-sales_Count | 2000 |
| Apple | Phone-sales_Count | 3400 |
| Walmart | Phone-sales_Count | 5600 |
| Costco | Phone-sales_Count | 1400 |
If you can please give me solution for any one of the scenario that will solve the purpose. Thanks in advance.
