columns

[raadwiptec]

hi all,

is there any way to add columns and get the total as in red

example as below. in red

the price is an expression.. not a dimension...

Jan	feb	mar
product	price	price	price	total
a	10	10	10	30
b	20	20	20	60

[sunny_talwar]

You can do something like this:

=RangeSum(FirstExpression, SecondExpression, ThirdExpression)

[Peter_Cammaert]

I guess you are using a pivot table with a Product dimension on the left and a Month dimension at the top. Add subtotals for the Month dimension and you'll get your total column.

[Anonymous]

try:

=sum(<total Product> Price)

[raadwiptec]

hi peter ,

yes iam using a pivot table

[raadwiptec]

hi sunny,

when I trying to use this iam getting every month the sum which is not correct..

[raadwiptec]

at the end I should have one total column.. i.e for product  a - total price is 30

[raadwiptec]

hi peter ,

if I do as u mentioned. I get the total price of all the products for jan month.. which is still not  correct.

it should be only column adding up to a total for a single product

[sunny_talwar]

Can you share a sample?

[Peter_Cammaert]

Switch to a subtotal for the other dimension and see what happens.

Don't hesitate to experiment in QlikView. You never know what great new tricks you'll discover.