Sorting of the Pivot with Data Bars

July 01, 2019 19:57

Hello Team

How can i sort the Pivot Table by its value from ascending to descending order at each category level . i have used data bar for the sales measure and i want to display the bars from lowest to highest within each category. See the screenshot below for you understanding

Please help me with this as i am stuck in very task and deadline is nearing

Comments

8 comments

Lokender Singh July 01, 2019 20:01

So what i am looking for is that under Furniture category furnishing has the lowest value so it should show at the top under Furniture category and then bookcases then tables and then chairs. Simiary for other categories which are office supplies and Technology should show their respective bars from lowst to highest

0

Comment actions Permalink
Andrew Block July 01, 2019 20:04 (Edited July 01, 2019 20:04)

If you sort the value "Ascending" this should accomplish what you want:

1

Comment actions Permalink
Michael Becker July 01, 2019 20:12

Hi Lokender,

Go to edit mode and go to easure you display with bars, you should see there following icon Clicking on it will changer sort order of that measure within each group. Hope it helps.

Regards,

Michał

0

Comment actions Permalink
Lokender Singh July 02, 2019 03:09

Hello Andrew , Michael

I am doing the same thing mentioned by you earlier but its not working for me

Regards

Lokender

0

Comment actions Permalink
Lokender Singh July 02, 2019 03:14

Since the above screenshot which is posted is of sample data. In my real world example I have one more dimension after the Subcategory which is Segment. is it because of that it is not allowing the sort to work in the way I am looking for

0

Comment actions Permalink
Lokender Singh July 02, 2019 04:25

Segment has only one value which is Consumer and may be because of this reason when i am applying sort then it seems to be not working . When i changed the order of the dimension in which they are placed like i placed segment before category and subcategory then it is working fine as i want but what if i want to keep the order of the dimension same as i want like category, subcategory and then segment then the sort is not working

Any input and solutions to this ?

0

Comment actions Permalink
Michael Becker July 02, 2019 06:52

Sorting in Pivot works only within he scope of inner most grouping. If you want to maintain grouping and sort by any column I suggest using this plug-in - https://www.sisense.com/marketplace/aggregated-table/

0

Comment actions Permalink
Lokender Singh July 02, 2019 18:59

Thank you Michael. It worked for me. Since i am new to Sisense i have some few doubts and questions which i am mentioning below.

1) When i am placing the image into the Report using the Image Widget. it goes and settle at the end of the dashboard . I want to move it in the top right corner of the Dashboard just like mostly we have logos on the top right hand corner of the dashboard but i am not sure how to do that. Even when i drag it to the top it occupies the Complete horizontal row and settles in the middle but i want to dipslay it in the top right hand corner. Can you tell me how to do that . Can we adjust the height and width of image widget by writing some script. if yes can you help me with the script

2) I have installed Hide Widget Title Plugin but i am noticing that i am able to hide the title only for the images in the dashboard but for text widget and pivot i am getting the option to hide title but its not working . Can you help me with this

0

Comment actions Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?