Hey Medelyn, Thanks for the reply,But actually there is no row at all for the specific category. Let me explain: 1. We have 2 year data (2019,2020,2021,2022) 2.Each year have category(car) and measure(making_cost)-e.g.2019 (maruti-10cr,Audi-2 cr,BMW-5cr) 2020 (maruti-3 cr) 3.As explained in the upper line ,in the year 2020 - there is no category i.e.Audi,BMW. So when we filter year 2020 then key value making cost is (missing) 4.So i need to treat the (missing) into '0' 5.By creating a calculative field for iF else ,we need at-least one column value to replace.
... View more
