Hi,
I have fields called Product and its measures related to the product.
In below table, Product and Country (Country A and Country B) are dimensions. Country dimension is being dragged top next to measure.
And Measure is a expression, which is pulled as a column next to product.
1. sum(value) as SUM
2. AVG(value) as AVG
Product A only has measure SUM not AVG, similarly Product B only has AVG not SUM.
| Product | Measure | Country A | Country B |
| A | sum | 10 | 10 |
| A | Avg | 0 | 0 |
| B | sum | 0 | 0 |
| B | Avg | 5 | 5 |
I want Measure AVG to be hidden for Product A, and Measure SUM to be hidden for Product B.
Output:
| Product | Measure | Country A | Country B |
| A | sum | 10 | 10 |
| B | Avg | 5 | 5 |
Thanks.
