Forum Discussion

SaCvP125's avatar
SaCvP125
Frequent Visitor
8 years ago

Merging Two Columns in Pivot Table

Hi guys,

 

Is possible to merge two columns in Pivot Table? I've a Indicator which aggregates two values by priority and I want to show the two values on same column father.

  
   
   
   

 

Thanks :)

Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi SaCvP125,

     

    Through the 'Query editor' pane you can merge columns the way you want, see the steps below:

     

    Step 1Step 2Step 3 

    You can use the newly created calculated column in visualisations just like normal ones

     

    Regards,

    L.Meijdam

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    SaCvP125,

     

    Your requirement seems not very clear. A complete example might be better. You may first check the Matrix visual.