Skip to Content
avatar image
Former Member

webi calculation


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 23, 2015 at 12:52 PM

    Hi,

    Where is issue.Are you not getting the sum  136 for Q1?how are you populating total values like 150?

    Amit

    Add comment
    10|10000 characters needed characters exceeded