Sorting straight table at the bottom

[Smeenakshi23]

Hello,

I have a straight table, The column in straight table be like , Product no, Date ,etcc.. For some product number the date values will be blank, i want to display those blank values at the bottom of my table..

For  example i need to display as below

Product No  Date

123            1/12/2018

123             1/13/2018

123           (blank)

546            1/12/2018

546            1/13/2018

546   (blank)

[jonathandienst]

Sort the table by Date - the nulls will go to the botttom.

[Anil_Babu_Samineni]

May be use this, If you are using 12 or more versions for Sort option by Expression?

Aggr(Only(TOTAL <[Product No]> Date), (Date, (FREQUENCY,DESCENDING)))

[Smeenakshi23 · Accepted solution]

Could you please how to help the above script for below scenario.

[Anil_Babu_Samineni]

To this, I don't think you need complex one. But, To answer your question Can you play around

TYPE --> Disable Y-Axis and all

Product No --> Just, Use Descending Order and Use measure for sort option the same what you showed condition and move to descending order.

[Smeenakshi23]

Thank you 🙂

Acutally, Type is field and i am not using it in table, i forget to mention that.. but what I did is , I added Type to the table, Sorted that to a descending  order and hide the column.