Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

comparing plan vs reality per columns and rows

Hello community,

 

I'm trying to figure out how to compare table with plans with reality.

 

For example I have this table for plans (in excel sheet)

 

CategoryProductJanuary PlanFebruary Plan
Product Category 1Product 1100150
Product Category 1Product 2250200
Product Category 2Product 350100
Product Category 2Product 47575

 

and I want to compare it with sales table not only per product and product category but also per month.

 

 

Any idea how to do it? I can change the plan table how I want.

 

Thanks in advance
MV

Need Help
Tutorial Requests

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    Can you provide you dataset and expected result screenshot, or privide sample output with your current dataset.

     

    Thanks,

    Jayant

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hello Anonymous, thanks for your help!

       

      Unfortunately I can't provide dataset, but in the dataset they important columns are Date; Product ID and Value.

      And in the 2nd dataset i have Product ID; Product and Product Category

       

      Kind regards
      MV