Forum Discussion
Matrix: how to add a (dynamic) Calculated Column ?
Hi all,
I created a matrix:
City | Confirmed | Cancelled
-------------------------------------------------
Berlin | 1.560.452 | 785.542
London | 1.102.210 | 425.254
Rows: City
Columns: JobStatus
Values: JobPrice
Now I want to add a calculated column at the end (after Cancelled colum) with the formula:
Rate = confirmed-column / cancelled-column
Result should be:
City | Confirmed | Cancelled | Rate
-------------------------------------------------
Berlin | 1.560.452 | 785.542 | 1,9864
London | 1.102.210 | 425.254 | 2,5918
Could you help me please?
Hello you can create seperate Measures:
Canceled=COUNTROWS(FILTER(DataTable,[Status)="Canceled"
Confirmed=COUNTROWS(FILTER(DataTable,[Status)="Confirmed"Ratio=DIVIDE([Confirmed],[Canceled])
Maybe you could create a table directly out of your data, but I'm not familiar with this.
It would be helpful to know more about your DataTable structure for further support.
Best regards.
5 Replies
Hello just add a calculated colum
Rate=DIVIDE([Confirmed],[Cancelled])
Best regards.
But where do I have to add these column? In the matrix diagram or in the data table?
Take a look at the screenshots please:
Thanks
Hello you can create seperate Measures:
Canceled=COUNTROWS(FILTER(DataTable,[Status)="Canceled"
Confirmed=COUNTROWS(FILTER(DataTable,[Status)="Confirmed"Ratio=DIVIDE([Confirmed],[Canceled])
Maybe you could create a table directly out of your data, but I'm not familiar with this.
It would be helpful to know more about your DataTable structure for further support.
Best regards.