If you are unable to create a new account, please email support@bspsoftware.com

 

unable to to create two related columns for count and total of values

Started by Lubomir, 29 Apr 2016 03:38:50 AM

Previous topic - Next topic

Lubomir

Hello, i found a problem with aggregation of data together.
What i need is to have two columns which one of the is showing count of particular items based on other data item and also total of another numeric value for same data item in crosstab.
I tried to make a data item with option count distinct aggregation, this work fine, but when i add another column for related numeric data it screwed up.

My imagination is:

value 1  - > value 2 - > value 3 - > count of item based on value 3 level - sum of numeric value for value 3 level
                              - > value 3- > count of item based on value 3 level - sum of numeric value for value 3 level
             - >value 2.....

As temporary solution i used two crosstabs one next other which for each option but id does not look very fancy.
I will be glad if exist some way how to merge it.
Thank you for advices.