Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Are you opening this dashboard from Access Point or from your local desktop?
Desktop
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
ok I published it on my profile.
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.
Hi Adam,
PFA. Solution.
I have used the same method i.e Calculated dimension and it's working as expected.
Regards,
Pankaj
oh sor you are saying that Diminsion limits work fine...hmm..interesting ....ok let me try again.