About aniruddhamauryaey

aniruddhamauryaey · ‎11-27-2020

@Anilkumarch It is a same list used in grid below and as page selector in attached screenshot(KPI3). Node names are published on rows in the grid and it has single line item - Cases Sold on page. When my selection is AOP V1 , I want to display all the nodes except PY, PPY and AOP V1. When my selection is AOP V2, then it should show PY, PPY and AOP V2 and similarly for AOP V3, AOP V4 selections. Just to confirm, my page selector is a flat list.

aniruddhamauryaey · ‎11-27-2020

@Anilkumarch Thanks for your answer. Yes, these two are hierarchy list, but requirement is to achieve it using list without using line item. Do we have something like dynamic appearance of saved views based on selection where for V1 only one view appear where values are for PY, PPY and V1. For V2 selection, second view where values are for PY, PPY and V2 should appear while rest of the views remain disappear.

aniruddhamauryaey · ‎11-27-2020

Hi All I am working on 2 subsets of a list where one list subset will be used as page selector in dashboard and other list subset is in row of a module. List subset A: V1, V2,V3,V4 List subset B: PY, PPY, V1 , V2, V3,V4 On dashboard, I need to show subset A as page selector and subset B in row. If I am selecting V1 in subset A, then it should show values for PY, PPY and V1 in view. If selection in V2 in subset A, then it should show values for PY, PPY and V2 in view and similarly for V3 and V4. How can we populate list values in subset B(rows) by selecting a values in subset A(selector). Attached is the screenshot for reference.

aniruddhamauryaey · ‎11-26-2020

@AWhitworth Thanks for your answer. I just wanted to be double sure for export configuration on Anaplan which is clear with your response. I am trying to install Excel Add in but Visual Studio is not running on my system, which is a pre-requisite to install Excel Add in. Have raised a ticket, Now I will look for configuration through excel add in. Thanks!!

aniruddhamauryaey · ‎11-26-2020

Hi All I want to take extract from new UX grid in attached excel format. This template has a special requirement of showing cells name which appears in drop down option highlighted in yellow in attached screenshot at top left corner. So when we select a value from drop down it refers to a particular cell in the sheet. Do we have option to do configurations in anaplan UI to generate the excel in desired format?

aniruddhamauryaey · ‎11-18-2020

Thanks for quick response Anil, It worked.

aniruddhamauryaey · ‎11-18-2020

Hi Anil, Thanks for your answer. I do not want to create a new list. Is there any other way to achieve this?

aniruddhamauryaey · ‎11-18-2020

Hi All, I have a List Dept L3 where I want to SUM my $ Values in a module by its Code i,e not a Code of my item but a text formatted property which says Dept Code. I want to apply Sum by 'Property code'(830) in a list as shown in attached snapshot. Highlighted items are child of different parents. 830 is the Property code for which, I want to sum the dollar value for '830_SupChn' and '830_TSP'. As this is a text formatted property, so SUM function doesn't work on it.

aniruddhamauryaey · ‎09-28-2020

Hi Everyone I am using '52' to show previous year data of same month by subtracting: 'PY Month(week)' - 52 Is there a function or alternate way to use replace '52' and not use it in formula as a number but a derived value from some function or calculation? Thanks!

About aniruddhamauryaey

Re: Dashboard view

Re: Dashboard view

Dashboard view

Re: Excel extract in attached format

Excel extract in attached format

Re: SUM by text Property: Calculation function

Re: SUM by text Property: Calculation function

SUM by text Property: Calculation function

Week Calculation-Alternate way to put number of we...