I've got quarter and month as dimensions in my crosstab as below:
Q1 Q1 Q1 Q2 Q2 Q2
Jul aug sep oct nov dec
no.of errors 25 35 76 56 55 77
total 150 100 120 130 190 120
Quarter total errors 136 136 136 188 188 188
I'm trying to get a quarterly total for no. of errors for quarter for which i'm using formula
=[no_of_errors] in([quarter])
But that's not working. Any help is much appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.