Skip to Content
0

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

Jun 01, 2017 at 01:03 PM

142

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Tammy Powlas
Jun 01, 2017 at 01:42 PM
0

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks Tammy for reply,

I am in AO 2.3, But am facing difficulty on how can I count Business Area as seen in snap. Please help.

count.png (122.8 kB)
count.png (122.8 kB)
0
Tammy Powlas
Jun 01, 2017 at 05:40 PM
0

Hi Rajiv,

=CountA should work

See below


1rajiv.jpg (197.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Rajiv Ranjan Jun 02, 2017 at 06:36 AM
0

Hi Tammy,

This will no work for the scenario as below..


counta.png (49.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
Rajiv Ranjan Jun 02, 2017 at 06:36 AM
0

Hi Tammy,

This will no work for the scenario as below..

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Have you tried doing this type of aggregation (count) in BEx query designer?

0

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...

0