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.
