Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Header 1 | Header 2 | Header 3 | Header 4 |
---|---|---|---|
Product | Asondate | Actualdate | Amt |
A | 2/26/2011 | 1/31/2011 | 100 |
A | 2/26/2011 | 2/16/2012 | 200 |
B | 3/31/2013 | 1/31/2013 | 1500 |
B | 3/31/2013 | 2/28/2013 | 100 |
B | 3/31/2013 | 3/31/2013 | 200 |
If I select As on Date 2/26/2011 then need to
calclulate sum of Actual date (1/31/2011+2/16/2012) it should be 300 can any suggest how I can
achive this in setanalysis
Thanks
If i understand correctly, what you want is Sum(Total <Asondate> Amt) as an expression in that chart
Thanks for reply.
If i select as on date 2/26/2011 fromlist box
Then total should be sum of Actual date Eg
1/31/2011 + 2/16/2012=300
Thanks
HI ,
You wanted the OutPut in the Straight Chart table ?
If so then have only Product and AsOnDate in the Dimension and try to have only sum(Amt) in the Expression.
If not then how you wantd to be seen in which object?
Please correct me.
//Yusuf
Hi
Im useing pivot table.in list box Asondate selected then total should be sum of actual date belongs to Asondate
Thanks
Did you try Sum(Total <Asondate> Amt) ?