Skip to Content
avatar image
Former Member

How to count list of values in dimension in Analysis Office for excel

Dear All,

Basically My question is how can I make calluclations like cont of list of values on Dimension in Analysis Office, Please help.

Thanks in Advance,

Rajeev.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 01, 2017 at 01:42 PM

    Hi Rajiv - I am not following this

    If you are on a later version of Analysis Office, you can use Excel formulas to do this, e.g. = COUNT(...)

    Perhaps you can share screen shots?

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 01, 2017 at 05:40 PM

    Hi Rajiv,

    =CountA should work

    See below

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 02, 2017 at 06:36 AM

    Hi Tammy,

    This will no work for the scenario as below..

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 02, 2017 at 06:36 AM

    Hi Tammy,

    This will no work for the scenario as below..

    Add comment
    10|10000 characters needed characters exceeded

    • You can also add an Advanced Calculation column with formula NODIM(1) and you'll get a counter for each row. Only works if you want the count of values for the lowest level of detail. Otherwise, put a counter in your BEx query with exception aggregation to count whatever DIM you care about...