Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to change table presentation using matrix like one

I have one table like the following one Item  Type Period Site capacity Demand % item1 18-Oct Site_A 120 10 8.33% item1 18-Nov Site_A 120 80 66.67% item2 18-Oct Site_A ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Create a matrix as below

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous in matrix it does need aggregation, and you can change the aggregation to max or min , it will meet your needs, only problem you will run into if you have multiple rows for item type and capacity, to overcome this, add a unique index column and put that on the rows, in that case it will never aggregate the values.