Hi,
There is a client requirement in which in a matrix visual i have to show the distinct count of promotions for which item is sold till now, in a separate columns in matrix visual.But the problem arises as we have Month field pulled in Columns inside a matrix.In rows there is company name and country name.If we pull our measures inside matrix under values then the count is further coming under month hiearcahy which we dont want.We want it as a separate column
Note:1)Comapany and year in rows of matrix
2)Month in columns
3) 11,12,17 ETC IS PROMOTIONS RAN coming from some other measure is dragged under values.
| Company | Year | | | month | | | count of promotions |
| | | april | may | jan | feb | march | |
| maruti | 2021 | | | 11 | 12 | 17 | 3=(here distinct count of 11,12,17) |
| hyundai | 2022 | | 12 | | 10 | | 2=(here distinct count of 12,10) |
| bajaj | 2023 | 10 | | | | | 1=(here distinct count of 10) |
