Error in Sales Analysis Report

tsv
Member Posts: 49
Hi,
I have created three dimension as Customer Group, Item Group, Sales Person Group and created coresponding values in Dimentions values
set the Dimension 1,2,3 code in Analysis View card with these three dimensions for analysis.
My line template as
Ref description Type range
Y1 Customer Customer group 1000..2000
Y2 Item Item Group 10..30
Y3 Sales sales Person 100|200
My Column template will be Budget(Column header) with "Net Change" as C0loumn Type and "Item Budget Entries" as ledger Entry Type
In "sales Ananlysis report" when i set the Item Group dimention filter (header) it is not reflecting in the Lines of
Y2 but it reflected in Y1, Y3.
and similarly when i set the Customer group dimension in the filter it is not reflected in Y1 but in Y2 and Y3.
is it a bug? or Did i miss any setup?
find the attachment too.
I have created three dimension as Customer Group, Item Group, Sales Person Group and created coresponding values in Dimentions values
set the Dimension 1,2,3 code in Analysis View card with these three dimensions for analysis.
My line template as
Ref description Type range
Y1 Customer Customer group 1000..2000
Y2 Item Item Group 10..30
Y3 Sales sales Person 100|200
My Column template will be Budget(Column header) with "Net Change" as C0loumn Type and "Item Budget Entries" as ledger Entry Type
In "sales Ananlysis report" when i set the Item Group dimention filter (header) it is not reflecting in the Lines of
Y2 but it reflected in Y1, Y3.
and similarly when i set the Customer group dimension in the filter it is not reflected in Y1 but in Y2 and Y3.
is it a bug? or Did i miss any setup?
find the attachment too.
with regards,
tsv
tsv
0
Comments
-
Hi,
Code are not integer values, maybe 10..30 include 2000.
Try something like 00010..00020 or 10|11|12[...]|30.
Regards,
dkone.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions