Advanced Set Analysis

[#1]

Hello

I'm looking for some advanced expression assistance with attached qvw file.

In the file there are some Ids associated to some regions and some numbers.

I'm looking to add a calculated dimension which will do a count of all Age_Buckets (column in the file) as one field.

For e.g. If you select AVI6 (second in the list) you can find two age buckets (0 to 1 and 2 to3) Both have individual counts (3 and 11 respectively)

I'd like to club/add both counts and display as one column so that users can see a consolidate count (which will be 14 in this case) of age buckets.

Apologies if this is some way confusing or too specific.

Thanks for your help.

[#2]

Remove Age_Bucket from the dimension.  This will roll your count to the 2 remaining dimension. recid and region.

[CELAMBARASAN · Accepted solution]

Go to presentation tab --> Click on Age_bucket which is in Dimensions and Expressions

and select show partial sums check box below.

You will get the total.

Celambarasan

[#4]

Hai,

Please find the attachment May  be this is what you are looking for.

Thanks,

Rathish

[#5]

Thanks everyone for your help.