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)
|Category||Product||January Plan||February Plan|
|Product Category 1||Product 1||100||150|
|Product Category 1||Product 2||250||200|
|Product Category 2||Product 3||50||100|
|Product Category 2||Product 4||75||75|
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
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