Its the Column "First Open Val" that I am struggling with.
If I only select 31/03/2011 and 30/04/2011 and no other selections, in "First Open Val" the amount for Asset Manager= A1 and Performance CAT ="E" should by 5621 for both, and if the date selection was for 12 months then the "First Open Val" needs to be repeated from the Lowest dates val for the 12 Months.
I am hoping that you might be able to help me with the next step that I need to do in this model.
Please see attached.
The FirstSortedValue works for the details, But I am not able to find a way to be able to represent 2 different graphs using the formula for “Asset Manager” and “Performance CAT”
If I create a new table for to perform the grouping it works although I end up with a Syn table, but if I create a second summary then the FirstSortedValue doesn’t work.
Any advice would be welcomed.