I never tried this but I just did. Certainly does not work as I would expect.
What is your actual question/issue?
As an example a table that has sales Qty, Date, Name.
You have a sub summary for sort on name. And select a certain month as the found set.
You can have a summary field count the qty for the month this can show in the sup summary part as usual.
If you want to use a chart in the sub summary part to show how many qty sold by that specific sales Name in that month per day it does not seem to work well.
I am not a fan of FM native charts anyway.
1 of 1 people found this helpful
"If you want to use a chart in the sub summary part to show how many qty sold by that specific sales Name in that month per day it does not seem to work well."
It is certainly doable; you need a few extra fields. See the attached sample file.
That is exactly what I was trying to do. The brevity of your code is humbling. The list function I use with charts but the cDateUniqueInGroup with GetNthRecord and the cQtySummarizedUniquePerDate using GetSummary are not in my repertoire. Will take me a while to understand why they work but will definitely be worth the time. Thank you for such a quick and useful response.