Help required in getting count

[manojkulkarni]

Hi All,

I have given sample data, where in each IP Address will be provided with 2 sources. I need identify the no of address assigned by Source wise considering both primary & Secondary for each IP. Please suggest how this can be achieved ?

Data :

IPAddress	Primary	Secondary
1	L1	L3
2	L1	L3
3	L1	L2
4	L2	L1
5	L2	L3
6	L3	L1
7	L4

Expected Result

Sources	CountIP
L1	5
L2	3
L3	4
L4	1

[effinty2112]

Hi Manoj,

                     If you want to use the calculated dimension in an expression just copy the Valuelist formula into your expression as if was a dimension field.

Here the whole ValueList formula in inserted into a Right() expression to get the number part.

Error: Garbage after expression: "L1'"	Right(ValueList('L1','L2','L3','L4'),1)
L1	1
L2	2
L3	3
L4	4

cheers

Andrew

[manojkulkarni]

May be question is not clear. What I meant is If want to use the Dimension Value "L1" or "L2" in set analysis of expression then how should we use ?