I have a model with the three lists; Cities_L3 which rolls-up to Countries_L2 which rolls-up to Markets_L1.
In module I am calculating amounts at the city level using FX rates which are different depending on the parent Country.
Is there a way I could summarise the cities to show a sub-total at Country level, but not sum all the way to Markets (as one Market could contain Countries which use different FX rates so the data wouldn't be useful at that level?
Thank you both - I suspected I would have to do something like this but as I have dashboards looking at this line item, and the user can choose the level they're viewing using the L3 list as a page selector, I was hoping there was a way I could control what levels were being sum'd. For now I can just disable the summary from the line item (better to show nothing that something that's wrong)