Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
No, that's not working for me. To be fair, I think maybe what I'm trying to do is not real clear.
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.
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?
I do sleep my friend
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?
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??
Sorry for the delay. Yes, I do have several dimensions in the chart.
Sorry. I forgot to answer your other question. I'm using a straight table.
This is probably not the best, but can't think of a better way to do this
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?