Getting Error in Calculated Dimension

[NavinReddy]

Dear Experts,

The experssion im using its not working on pivot table

its giving "Error in Calculated Dimension "

=count(aggr(Only({<Month=,RAG_RATING_CD={'R'}, MonthYear={">=$(=date(MonthStart($(vMonth)),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}RAG_RATING_CD), Metric))

Can some one help me where i am doing wrong

Any Suggestions

Best Regards,

Niranjan

[sunny_talwar]

Try this without the outer aggregation -> Count in your case:

Aggr(Only({<Month=,RAG_RATING_CD={'R'}, MonthYear={">=$(=date(MonthStart($(vMonth)),'MMM YY'))<=$(=Date($(vMonth),'MMM YY'))"}>}RAG_RATING_CD), Metric)

and may be you need to use Count(Metric) as your expression.

[swuehl]

Maybe you can clarify what you want to achieve.

As far as I can see, the advanced aggregation expression will return at most a single distinct value across your Metric aggr dimension, 'R'.

So not sure why you want to use a (calculated) dimension at all here.

Or are you trying to mimic an expression that is only shown once in your pivot table?

In any case, it would be more than helpul if you describe the context you are using this expression / dimension in more detail (Other dimensions, expressions, relation and values of your fields you are using might be helpful, too).

[NavinReddy]

Hi Sunny & Stefan,

Thanks for your reply

i just want to display numbers  and including percentage with 3moths of data

i have attached sample application please help me

pivot table im not able archive

Best regards,

Niranjan

[swuehl]

Which part is not working and what do you expect to see?

[NavinReddy]

Hi Stefan,

Top pivot table working fine but want to display 3months data including percentage

bottom table im able to display numbers & percentage but i just want to display top pivot table format

Best Regards,

Niranjan

[NavinReddy]

Hi Stefan,

please find the attachment revised application

i just want to merge both the above pivot information like bottom chart look like

please any way to do this

Best regards,

Niranjan

[sunny_talwar]

Niranjan -

It seems that you are able to achieve what you are looking for in the bottom table. Am I missing something? What exactly are you unable to achieve?

[NavinReddy]

Hi Sunny,

Good Morning,

for attached sample application i just want show numbers and Percentage in one pivot table

now i am displaying the information in two tables

Best Regards,

Niranjan

[sunny_talwar]

But isn't the buttom table has both of them?