How to write accumulation for count.....

[chinnu123]

Hi Team,

I am facing a this issue from long time can any one please help me out to solve this..

I am having a target tickets and resolved tickets. I need to show the Percentage of those tickets  in bar chart

For Example  If current month is

June then April target tickets+ May target tickets+june target tickets/total resolved tickets which includes 3 moths resolved tickets

if it is July then-April target tickets+ May target tickets+june target tickets+july target tickets/total resolved tickets which includes 4 moths resolved tickets.

Note:Nulls to be excluded

and my dimension is Month and tear fields

Can any one please help on this

Thanks,

Chinnu

[johnw]

I'm unclear on your exact requirement, but it sounds like setting "full accumulation" might do the trick.

Another approach is to use an AsOf table.

The As-Of Table