Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create table sum value by month

Hello everyone,   I need help to create this table : I try some tips but I cannot do it..   Name sum January sum February sum March sum April sum May sum June sum J...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may put Month level of [PLOT DATE] date hierarchy into Columns box of Matrix visual, put [Value name] into Rows box, put [Value] into Values box , set aggregation as "Sum".

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I obtain this table :

 

 

 

 

But I would like to invert Columns and rows.

Like month on first rows and value name on first columns.

 

Thank you in advance

v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

You may put Month level of [PLOT DATE] date hierarchy into Columns box of Matrix visual, put [Value name] into Rows box, put [Value] into Values box , set aggregation as "Sum".

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.