Forum Discussion
Measure based on column value
Hi, I'm have to make a page showing the status of our commercial agreements, this agreements have goals based on products categories or types by period.
The problem is that i don't know how to make this in a way that the measures to calculate total and amnt can be dynamically asigned.
For example:
IF Category or sub-category are different, differents measures muste be used to calculate the total.
The same to TYPE.
In the period case I think i have a solution, but for the other part the solution still avoids me.
Can you help me?
Thank you very much.
HI marcos_osorio ,
The simplest way is enter to the query editor and do unpivoted columns on value fields. Then you can use customer field and unpivoted attribute field, value fields to create a matrix visual.
Regards,
Xiaoxin Sheng
1 Reply
HI marcos_osorio ,
The simplest way is enter to the query editor and do unpivoted columns on value fields. Then you can use customer field and unpivoted attribute field, value fields to create a matrix visual.
Regards,
Xiaoxin Sheng