Team,
I am looking for the below calculations. I am pretty new to Qlikview.
I have got the following fields
Company PrevYearSales CurrYearSales PrevYearMarketShare CurrYearMarket Share
A 3.2 5.2 10 / 3.2 13 / 5.2
B 4.5 4.8 10 / 4.5 13 / 4.8
C 2.3 3.0 10 / 2.3 13 / 3.0
Total 10.0 13.0
How do I define the calculations for the last two columns? I am not able to access the Total of the sales columns.
The sales columns are calculated fields and are defined as expressions.
Please advise.
Regards,
Sudha