How to calculate Bill type summation?

[#1]

Hi ,

I have data like below

Date	Billtype	Queue	LOB	Value
4/1/2014	UB	DE	A	10
4/1/2014			B	20
4/1/2014		VER	C	30
4/1/2014	HCFA	DE	A	1
4/1/2014			B	2
4/1/2014			C	3

i need result like below

Dae	Billtype	Queue	LOB	Value	Result
4/1/2014	UB	DE	A	10	60
4/1/2014			B	20	60
4/1/2014		VER	C	30	60
4/1/2014	HCFA	DE	A	1	6
4/1/2014			B	2	6
4/1/2014			C	3	6

[alexandros17]

But what is the logic to sum values to obtain result?

Data is the same and other fields are not present in all records.

How to aggregate Result?

[rohit214]

can you please share the sample data

thanks

rohit

[tresesco]

For Result column, try expression like:

Sum( Total <Billtype> Value)

Assuming you are using straight table.

[#5]

you can take below inline table for sample data.

load * inline[

Date	Billtype	Queue	LOB	Value
4/1/2014	UB	DE	A	10
4/1/2014			B	20
4/1/2014		VER	C	30
4/1/2014	HCFA	DE	A	1
4/1/2014			B	2
4/1/2014			C	3

];

otherwise you can below attachment.

Thanks,

Ashok.

[#6 · Accepted solution]

Thanks yar it working fine but little change only.

sum(Total<Billtype,Date>Value).

Thank u very much it helped alot.

Thanks,

Ashok.

[#7]

Hi,

Please find the attached QVW.

The end result of the chart is

[arjunkrishnan]

Use This Expression Very Helpful For U

(=aggr(NODISTINCT Sum(Value),Billtype))

And

Lets Pls Find The Attachment It's Very Much Helpful For U..!

Regards By

ArjunKrish

[#9]

Hi Tresesco,

I have one more question ,i need same result format as like above but i need previous month bill type total.

i am using below expression

sum({1<Monthname={'$(=monthname(admonths(max(date),-1)))'},Billtype>}Value)

but it gives overall total not bill type wise.

Thanks,

Ashok.