Exclude certain cells in total/aggregation dimensions

Hello Nadia,
 
As I understand from the approaches you linked, only through the latter is what we want possible - i.e. visible dimensions that are excluded from totals?
Unfortunately, our use-case demands that certain data be both visible but excluded in totals calculations. Implementing a custom data source API seems excessive for what we want to achieve. There is no known workaround to achieve what we want without implementing a custom server?

Best Regards,
Jonas

Hello Nadia,
 
This may be a necessary workaround. However, it may prove to be slightly complex in some of our cases where we have multiple calculated/totals rows (nested children). I'm worried that implementing custom dimensions in this case can impact other functionality of our application such as formatting and whatnot.
Could we perhaps modify the existing totals dimensions by using customizeCell to alter each cell's .text property to simply display the calculated total? This would obviously only be visual but since these dimensions are not to be interacted with either way, it may be the safest way to go?
 
Thank you for all your help,
Jonas

Hello Nadia,
 
Thank you for your help. We will see if we can't figure something out. We would also like to formally request that FlexMonster perhaps look into allowing custom totals logic in the future (that does not require a separate API).
 
Best regards,
Jonas

Hello Nadia,
 
Thank you very much for adding it 🙂
 
The closest comparison I can draw from is Excel, but this kind of works "the other way" around from how FlexMonster does it. Instead of automatically generating totals dimensions, the user has to specify the function (e.g. SUM) and the input (Columns A->C e.g.)
 
This gives the user free reign to include whatever data they want the column to represent.
 
Since FlexMonster kind of works the inverse of this, by providing totals dimensions that include all child-members "out of the box", I would imagine that this feature would work the inverse of Excel's. Instead of explicitly adding dimensions to be included in the total, I would expect that I could specify which members to exclude.
 
As a software developer I would expect the first iteration of this to be in the form of some function API or similar. Maybe a function similar to customizeCells() where, instead of iterating over cells automatically, it iterates over every totals dimension. Here we could then apply our own rules. E.g. something like:
 
if(totalsColumn.members.includes("[ColumnIWantExcluded]")){
 
}
 

if(currentTotalsColumn.member.includes("[columnIWantToExclude]")){
currentTotalsColumn.exclude([columnIWantToExclude])
}

 
A front-end UI to allow for maximal user-friendliness of this would likely be in the form of a multiple-choice drop-down menu wherein the user would be able to (un)tick whatever dimension they want included in the totals column. This would no doubt take more work and it's not necessarily a must-have for us as we mostly develop our own solutions. But I could see it as a benefit for allowing easier use of the feature.

Thank you for your help,
 
Br
Jonas

Hello Nadia,
 
I am writing again to inquire about potential developments in the matter, or if you could help us with a workaround.
 
We managed to create a rudimentary workaround for this issue where every newly generated dimension would have a partner every cell of which was the inverse of the first dimension. E.g.
Custom Dim A: Cell 1 = 500
Custom Dim B: Cell 1 = -500 (hidden from view)
Static Dim: Cell 1 = 1000
Total = 500+-500+1000 = 1000
In summations this effectively excludes the Custom Dim values from the sum.
 
Unfortunately, in cases other than sum, such as averages, the mere presence of these columns will still impact the total result. E.g. 
 
Custom Dim A: Cell 1 = 500
Custom Dim B: Cell 1 = -500 (hidden from view)
Static Dim: Cell 1 = 1000
Total = (500+-500+1000)/3 = 333.33
 
When we want either
Total = (500+-500+1000)/1 = 1000
or
Total = 1000/1 = 1000
 
I had a look at your earlier example again as it may prove relevant for us: https://jsfiddle.net/flexmonster/dj0b97y1/
 
However, in the example it seems all the totals are still drawing from every column. If it's possible, could you perhaps modify the total column illustrate total average of price and then have that result exclude the "Warehouse" column?
 
I had a look at the customzieCell() function as well. Unfortunately, without access to the logic that calculates the totals it is extremely difficult to have function.
 
I apologize for pressing further on this matter, but this feature is very important for the functionality of letting users create custom dimensions.

Hello Nadia,
 
Thank you for your help. We will look around for other workarounds. Please keep us updated if any developments on this matter arise 🙂

Best regards,
Jonas

Hello FM support team,
 
Sorry to bother you again, but I have been asked to prompt once again on the matter of defining a custom aggregation (without the need for a custom API). It would be an extremely critical feature for us.

Please keep us in the loop.
 
Best regards,
Accobat