in the above flat file, i want to get a count for first column data. for example in the first column, how many times "8116" present in the sheet ? count from column 2nd column till Mgr4 column. in this example "8116" present only once but "32521" present 7 times. I can achieve this in excel. How can i achieve this in Anaplan? Can any one please help me?
First create a list of OPIs in your model and and then use that list as a dimension in your module. Create other line items as OPI list formatted line items. Use SUM & LOOKUP in your Result Line items to get the desired count on any of these columns.
Note: Don't use SUM & LOOKUP together as there are performance issues.