Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Thanks yar it working fine but little change only.
sum(Total<Billtype,Date>Value).
Thank u very much it helped alot.
Thanks,
Ashok.
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?
can you please share the sample data
thanks
rohit
For Result column, try expression like:
Sum( Total <Billtype> Value)
Assuming you are using straight table.
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.
Thanks yar it working fine but little change only.
sum(Total<Billtype,Date>Value).
Thank u very much it helped alot.
Thanks,
Ashok.
Hi,
Please find the attached QVW.
The end result of the chart is
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
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.