Please see if the below could give some ideas:
0. You can tell if it is a Total Row if the MIN(value)<>MAX(value).
You can then add that Flag to the Color shelf along with loss/gain
1. You can make a conditional statement to return only a $ when desired:
IF [p.Choose Metric 2]="Annual Rent" THEN "$" END
This can be placed in front of the [value] on the label
2. Because of the splitting up by Agency, I'm not sure if there will be a way to collapse 40 South.
You could try making Location-Agency a hierarchy, then you would have the ability to expand and collapse
by using the +/- icon next to the top Location label.
3. There might be a way to do it using:
Alternatively, you could use a parameter for the target month,
but would need to keep in mind that parameters are static and would need to be manually updated when new data hits
4. Looks pretty nice.
Please see Sheet 6 of the attached in the Forum post.
254416diff.twbx 889.3 KB