Forum Discussion

Karthik12's avatar
Karthik12
Post Patron
3 years ago

Table Visualization from 2 different tables

Hello Folks, GM.  I am developing a production data display whereas data comes from 2 different tables. I would like consolidate in one matrix/table visualization as below   Expected format (Fil...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Here's my suggestion

  1. Rename the Qty columns to Quantity in both tables
  2. Insert Type column with entries as Production and Plan in each table
  3. Append the tables
  4. Write these measures
    1. Pl_qty = sum(Data[Plan])
    2. Pr_qty = sum(Data[Production])
    3. Gap = [Pr_qty]-[Pl_qty]

Hope this helps.