Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a sample inline table :
A:
LOAD * INLINE [
Product , Revenue
A, 5000
B, 10000
C, 15000
D, 7000
E, 4500
F, 5600
G, 7000
H, 6000
];
i wan' t to create a third column it shows cumulative values from "Revenue"
what can i use , i have little idea to use rangesum() and above function. but nt able to get output.
Thankx
RangeSum(Peek(Revenue),Revenue) as ProgressiveRevenue
RangeSum(Peek(Revenue),Revenue) as ProgressiveRevenue
Hi ankit,
Please try this
Load *,RangeSum(Revenue,Peek('Cum')) as Cum;
LOAD * INLINE [
Product , Revenue
A, 5000
B, 10000
C, 15000
D, 7000
E, 4500
F, 5600
G, 7000
H, 6000
];
Hi,,
PFA
hope ur requirmnt
Thank you
Suresh
Hi Ankit,
Try this script below
A:
LOAD *,
RangeSum(Peek(CumRevenue), Revenue) AS CumRevenue
INLINE [
Product , Revenue
A, 5000
B, 10000
C, 15000
D, 7000
E, 4500
F, 5600
G, 7000
H, 6000
];
Regards,
Jagan.
Thank You for instant replies