Comparing customer vs customer group

Fri, 27 Feb 2015 11:42:47 GMT

Hello,

I would like to have two rows in a chart, the first one with the sales for a choosen customer

and the the other the sales for the customergroup the customer belong to.

For the choosen customer is there no problem but for the customergroup do I get the same

result as for the customer when I use this :

Sum({$<$(PeriodID = {$(=Max(PeriodID))},KundNr={"*"},KundGrupp={05},
Year = ,
Quarter= ,
Month= ,
Period=)
>} [DebPris]/100)

I know that I can do this by Alternate State but I will have it in one chart so I can show how the sales is

toward the Group.

Håkan

topic Comparing customer vs customer group in QlikView