Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Splice data from 2 tables

   Hi there!   I have 2 tables that have a quantity and a cost. Ideally, they would be in one table, but the calculations are too complex to have them combined.   In this simplified example, I h...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Found a way!

     

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Anonymous

Please look at my test, steps are below

In query editor

1.Merge queries as new

2.in the Merge 1 table, expand columns from table Dogs

3. add two custom columns to calculate sales for Dogs and Cats

4.select the two custom columns "Sales for Cat" and "Sales for Dog", then select "unpivot only selected columns"

5.add a conditional column to define which categoary each value belong to, Dog or Cat.


6.add columns in the chart 

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for your reply Maggie,

     

    I was hoping to do it without merging queries since I have many calculations that would not work in a merged query.

     

    I appreciate your time!

     

    There may not be a way...