I'm trying to create a filter pane that has a dimension with a frequency that is formatted with a comma seperator. I am using the below but is there a way to get the dimension to be left justified and the expression part to be right justified so the columns line up.
=if(isnull( [Business Line]) ,null(), [Business Line] & ' | ' & num(Aggr(Sum(Attempts), [Business Line]),'#,##0') )
Somthing like this.
Collections 1,201
Bankrutpcy 50
Legal 10,215