• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Needs to sort data in dashboard

Ratan Bhushan

Ratan Bhushan

Member
Hi Team

With your help guys, I am making a dashboard. I need your help again.
Here in my dashboard I have made CURLY BRACKETS where I need your help. In my file, there is a sheet named "Sorted Data for Qunit" from wheer I want data in my sheet named "Dash". But I want in a sorted way. If user selects one of the given range where I have written how data will react, must show.
Please check the file and help.
More data will be uploaded in coming weeks in the file
 

Attachments

  • PSTN_DashBoard_New.xlsx
    147.6 KB · Views: 9
Somendra Misra said:
Hi Ratan,

See the file.

Regards,
Click to expand...
Hi sir

sorry for late reply

The way I amlooking the data to be work like I have found in a dashboard at chadoo website. I am uploading it.
The way you have achieved is marvelous. I am also lookin for name but in the below way.
Please to advise if it can be achieved.
 

Attachments

  • dashboard-table-scroll-and-sort.xls
    185.5 KB · Views: 8
Somendra Misra said:
@Ratan Bhushan

Do you want fixed sorting as I did with names or variable sorting as per column selected by check box as shown in sample?

Regards,
Click to expand...
Sir

the way I am looking for sorting is when 3OCR column is sorted, then this column will sort large to small, but along with this the respective row will move. Like we do sort data in excel, on the basis of one column, whole data move from up to down or down to up along with the name.
In dashboard, choice to be given to the user on which column sorting is required. The names will move accordingly. As the sorting is in the file which I uploaded just now sir.
With Regards
 
Sir one thing, please advise, I am loading another file. In which there is week to be selected by user, can we get the data according to week. I have written required data there
 
Sir one thing, please advise, I am loading another file. In which there is week to be selected by user, can we get the data according to week. I have written required data there
 

Attachments

  • Test filter.xlsx
    51.4 KB · Views: 3
  • Test filter.xlsx
    51.4 KB · Views: 4
You must log in or register to reply here.
Back
Top