Error In Calculated Dimension Help

[pnn44794]

Hello:

I have the following Calculated Dimension.

I'm not sure why this is throwing an error.  Am I missing something simple?  The idea is to then use the Dimension Limit to show the largest 20 only.

Thanks in advance for any and all help.

[pnn44794]

No, that's not working for me.  To be fair, I think maybe what I'm trying to do is not real clear.

[pnn44794]

P.S.  Do you ever sleep?  You always seem to be responding to various people.  Just so you know, thank you!  It's appreciated, at least by me.

[sunny_talwar]

Would have been helpful if you shared a qvw file, but I created this chart... can you let me know what the expected output here would be?

[sunny_talwar]

I do sleep my friend

[pnn44794]

Hello Sunny:

I would expect to see the first 20 rows.  Then, I'm looking to have one more row for Others (all the other rows combined which would have a total quantity of 3,953 (15,321 - top 20 quantity of 11,368).  When I filter by order_date_quarter, I should get a top 20 for that quarter and one Others row.  I also need totals to show.

Does this make sense?

[sunny_talwar]

It does.... one quick question... do you have multiple dimensions in your chart (the way I showed). Also, are you using pivot table or straight table??

[pnn44794]

Sorry for the delay. Yes, I do have several dimensions in the chart.

[pnn44794]

Sorry.  I forgot to answer your other question.  I'm using a straight table.

[sunny_talwar · Accepted solution]

This is probably not the best, but can't think of a better way to do this

[pnn44794]

Would a pivot table work better? I’m open to it. ☺ If not, this is better than what I have. You only sent an image, right? No code?