To find unique charges based on ID,REGION.

[hamzabob1]

Hello all,

I have one problem can u please help me out.

ID	TRANSACTION NO	REGION	TAX	VALUE
B1	T1	ABC	50	100
B1	T2	ABC	50	200
B1	T3	ABC	50	250
B2	T4	XYZ	25	500
B2	T5	XYZ	25	750
B3	T6	PQR	30	200
B3	T7	PQR	30	350

I need to calculate sum of VALUE w.r.t ID.

EX:  ID = B1

       VALUE = 550

As per the scenario the TAX will become 150, where as I need to consider it as unique(i.e., only 50 because my ID is B1 only)

so the final result should display as follows

________________________

ID: B1

Transaction count: 3

Region: ABC

TAX: 50

VALUE: 550

___________________________And also require Region wise as below

Region: ABC

TAX: 50

VALUE: 550

Region: XYZ

TAX: 25

Value:1250

_____________________________

Thanks in advance

[sunny_talwar]

‌for 1st requirement:

Dimension ID

Expression

1) Count(ID)

2) Only(REGION)

3) Only(TAX) or Sum(Distinct TAX)

4) Sum(VALUE)

[maxgro]

maybe

sum(VALUE) / avg(TOTAL <ID> TAX)

[sunny_talwar]

‌For second requirement:

Dimension: REGION

Expressions

1) Only(Tax) or Sum(Distinct TAX)

2) Sum(VALUE)

[Anonymous]

Hi

are u looking for this ?

ID	=Only(Tax)	=Sum({<ID={'B1'}>}Value)	=count(Transaction)	=Only({<ID={'B1'}>}Region)
		550	7	ABC
B1	50	550	3	ABC
B2	25	0	2
B3	30	0	2

[kavita25 · Accepted solution]

PFA..

Regards,

Kavita

[hamzabob1]

Thanks everyone its working fine...

thanks again.

[hamzabob1]

Now i have one more ID with the same TAX like 30,50...

and i want to show in text box..

thanks in advance...

[Anonymous]

what is your expected output?

[kavita25]

Please elaborate ur requirement...with the expected result