Pivot issue

[#1]

I have an issue with a pivot I just did (Im a newbie at qlikview)

I just did this pivot that shows the subscription renewal count for each of our products. Now at the end (next to 13) I want to add the average count for each product and maybe also the average customer lifetime value(it should be average count * product price).

But How do I add that at the end of the pivot?

[#2]

Swuehl - you are my hero!

I tried to format the numbers, but the average count and the standard count should be formated differently, so it's hard to get right.

[swuehl]

Ah, I see.

Instead of the number format tab, try using the num() function around your calculation expressions (setting the number tab format to 'expression default'):

=if(SecondaryDimensionality()=0,

num(sum(aggr( count*count(count),product_id,count)) / sum( aggr( count(count), product_id,count)),'###.00'),

count(count))

)

[#4]

Can't I just add you to Skype - that would SO great 🙂

Thank's for your help - I would have never figured this out by myself... Now I just need to figure out what the expression means, so actully will learn something 😄