Excel pivot in Anaplan

akprasa1
akprasa1
in Modeling

Hi Anaplanners,

 

i have a situation wherein i need to build a sub-report using a  excel raw data file provided.The sub-report is just an excel pivot that needs to be replicated in Anaplan with the same functionality that excel has ,eg,Multiple select filters,multiple tabular view based on selection,sum values etc

 

Can someone  provide some best practice to achieve this?

 

Thanks in Advance

 

Tagged:

Answers

  • Misbah
    Misbah

    @akprasa1 

     

    Can you please take a snip of your excel pivot and share it here. It should be easily doable

  • akprasa1
    akprasa1

    Hi ,

    Attached is the snip of the pivot.

    Filters are applied on :

    ABI_SFA_CH_Cluster__c
    ABI_SFA_Recordtype__c
    LUX POC's exclusions

    BDR_M2_name

    Pivotname

    ABI_SFA_External_ID__c(unique count)

    ABI_SFA_Container_Type__c

     

  • Misbah
    Misbah

    @akprasa1 

     

    Still not clear how is this end result getting created. Here are my suggestions

     

    You need to see on what dimensions are you aggregating the data on. 

    You need to see if there is any hierarchy involved.

    If you need same multi tabular format, you may want to have a SYS modules created. You may end up having Subsidiary views

     

     

Categories