cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mvyskala Regular Visitor
Regular Visitor

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

2 REPLIES 2

Re: comparing plan vs reality per columns and rows

Hi @mvyskala,

 

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

 

Thanks,

Jayant

mvyskala Regular Visitor
Regular Visitor

Re: comparing plan vs reality per columns and rows

Hello @jayant_patel, 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