Hi Anaplanner,
I'm import data like this, but i want to sort data based on color before im import to another
after import the data will be like this
can anaplan provide like that?
Thanks,
Panji
@Panji,
I would like to know few things before try and answer this,
May I know the reason for sort and import?
Based on what factor you are sorting there (categorized as color)?
Are you ignoring the non-colored rows?
It would be great if you can help us with this.
Sandeep
Hi @sandeep_bk ,
the reason is i want to make a journal, and the color just a note that data(color) will be import to create journal, and the sort will be order like a picture 2.
Hi @Panji,
My question here is, based on what method of sorting(or logic) you arrived at picture 2?
Is this import data file keeps changing or is it a static import you do once?
If you need functionality like a sort and a filter to arrive at picture 2, we need to know the method behind your sorting and color-coding so that we can have some logic in Anaplan to do so.
if you are simply selecting/marking a few rows in the file based on your assumption, then you will have to do the same in Anaplan to achieve so ( Select the required rows and save as view )
Let us know if you need any further help
Hi @Panji,If you want Anaplan to color automatically then I agree with @sandeep_bk it would e helpful to know what's the logic for coloring.If you are asking if Anaplan can sort by color the answer is there is no native capability to do so however it's very easy to accomplish. If that's your goal let me know and I'll explain one way to do that.
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
