DMManalili
Frequent Contributor

Filter/Sort

Hi,

Question please. I am trying to use a system filter in my report module so that I can see first the start date of the project after the All Periods (sum). The filter is working, however, when I put the All periods on the left side column the filter will not work. I need to show in my dashboard the columns, first the All periods which is the summary of the values then follow the beginning month of the project. How can I show the All periods following the begining month? Thank you.

System Module

DMManalili_0-1608109949323.png

Report Module

DMManalili_1-1608109972981.png

12 REPLIES12
DMManalili
Frequent Contributor

yes i select the item to show so the All periods will be at the beginning time.
Misbah
Moderator

@DMManalili

You could have usedTotals Positionoption but the problem with that is that "Total Periods" is not considered to be part of the group & it won't be able to come at the front. But if you have to display only one year then this option might work because it will pull all all FY columns first . Try "Group at Start" or "Before" Option

Misbah_0-1608129546776.png

Misbah_0-1608129621095.png

Misbah

DMManalili
Frequent Contributor

Yes, but the projects have more than one year period. Thank you:slightly_smiling_face: