Sorting

[jadams123]

This question may be difficult to ask but i'll try.

My object is in a straight table.

So I have one dimension with is called (Category). This has Beverages, Breads, Milk e.t.c

But I have multiple calculated expressions (Sales, Margin, Margin % e.t.c)

One of the columns is called "Contributor" and this column is in %.

I have sorted it my lowest to highest %.

But I only need to show first 10 categories. The rest I don't want to show.

How can I do this..

J

[vishsaggi]

Are you opening this dashboard from Access Point or from your local desktop?

[jadams123]

Desktop

[vishsaggi]

So just save a copy and upload here. You can scramble the data if your data is sensitive and upload.

Preparing examples for Upload - Reduction and Data Scrambling

[jadams123]

ok I published it on my profile.

[vishsaggi]

Where exactly you copied on your profile i cant find any qvw file there?

You can upload your file like once you click on reply - > Go to top right corner of that reply window where you can see use advance editor, then you can see an attach symbol on bottom right corner.

[passionate]

Hi Adam,

PFA. Solution.

I have used the same method i.e Calculated dimension and it's working as expected.

Regards,
Pankaj

[jadams123]

oh sor you are saying that Diminsion limits work fine...hmm..interesting ....ok let me try again.

example.xls (J-Adams-123)‌