comparing plan vs reality per columns and rows

[mvyskala]

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)

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
MV

[Anonymous]

Hi @mvyskala,

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

Thanks,

Jayant

[mvyskala]

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