Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Sales Analysis by location

Posted on by 95
Hi Experts, 
How can I generate a sales analysis by location (columns) for particular service items? I set up the analysis lines and columns, but when I executed the report, it showed the overall total for all locations. I need the totals for each location in separate columns.
 
 

 

 
 
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 279 on at
    Sales Analysis by location
    Hello,
     
    The 'Item Filter' field can only hold a maximum of 250 characters.
    We will need to get around it.
     
    1. Export the data without filter and delete the unnecessary records.
     
    2. Finetuning the 'Item No.' to easily filter them. For example, add keywords at the front or back and utilise wildcard filters such as A* or *A.
     
    3. Create new dimensions for these items and use the dimension filter on Analysis View. However, historical records will not be retrievable.
     
  • PETERFL Profile Picture
    PETERFL 95 on at
    Sales Analysis by location
    Hi Experts. 
     
    When I try to filter the service items I am the following error 
     
    The length of the string is 327, but it must be less than or equal to 250 characters.
     
  • Suggested answer
    Yi Yong Profile Picture
    Yi Yong 279 on at
    Sales Analysis by location
    Hello Peter,
     
    It seems like you are using 'Sales Analysis Reports'.
    You should use 'Sales Analysis Views' as shown by YUN ZHU.
     
    You can use the 'Item Filter' to filter to the 25 items you want to view.
    Simply select them individually with control + click action and the system will filter them accordingly.
     
    I will suggest you to read https://learn.microsoft.com/en-us/dynamics365/business-central/ui-enter-criteria-filters, you can do filtering without the item being in a specific range or item # sequence.
  • PETERFL Profile Picture
    PETERFL 95 on at
    Sales Analysis by location
    The items that I want to see on the report are specific service items defined in Sales Analysis lines, I do not want to see the entire item listing, The 25 items are not all in a specific range, or  item # sequence
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 64,237 Super User on at
    Sales Analysis by location
    Hi, I simply tested it and it seems there is no problem. Hopefully the information below can give you some tips.
     
    Thanks.
    ZHU

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans