I need your help with the pivot table. I have one dimension - quarter. I want to use function rangesum and before and i want to count sum of volume (no separately for every one quarter, but as Q1=Q1, Q2=Q1+Q2, Q3=Q1+Q2+Q3 and Q4=Q1+Q2+Q3+Q4), for this i used rangesum and before, it is working in separately expression for one company. Later i put the same expression for counting of volume for all companies and in last expression i put column(1)/column(2) because i want to see relative number.
But when i do it together with three expression is working correctly, when i put everything in one expression is not correctly - without grouping and always it is counting just separately for every quarter. I really would like to see pivot table just with one expression and with right results - how i described.
Here i send you document, open and read script it is easy, chart named 'try' is correct, but my question is, wheather is possible to create it in chart, without using so long script? I read about function before, how can i use it correctly?
