Need help in aggregation of values

[Anonymous]

Hi I am new to Qlikview, I need some help on the issue I am stuck here. I tried to pull the sample data from the Excel sheet and when I tried to pull that data using the table view sales are not getting aggregated, please refer the below screen shot and give me some suggestions to proceed further on this. Thank you

[Anonymous]

Hi,

From how you explained, the table view will only show what exactly is in the table.

To see an aggregate, try using a straight table graph with Item as a dimension and as a measure, you can have sum([R_POS Sales Actual])

[rubenmarin]

Hi Harsha, Qlikview draws a row for each combination of dimension values. You use TOTAL to ignore (some) dimensions, ie:

sum(TOTAL <Item> [R_POS Sales Actual])