Multiple Selection like Excel Pivot

AdamSayyad
AdamSayyad
in Modeling

I want publish this below list on ux pages and give end user option to select multiple item from list like we have option in Excel Pivot table.

Is this function available in Anaplan or can anyone suggest me alternative function can be used.

There are multiple line item in the list. The final goal is to sum the number from source model based on this selection.

Anaplan PS

image.png

Excel PS

image.png
Tagged:

Answers

  • devrathahuja
    devrathahuja

    Hi @AdamSayyad ,
    You can create a similar functionality by using a boolean line item in the SYS module & use that for custom summing. The formula would be If boolean then value else 0. You can then show it at the top level to give a summary value if required.

    However, do consider if this functionality needs to be by user as that'd expand the calc module by a lot.

Categories