Error in Sales Analysis Report

tsvtsv 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.
with regards,
tsv

Comments

  • dkonedkone Member Posts: 59
    Hi,

    Code are not integer values, maybe 10..30 include 2000.

    Try something like 00010..00020 or 10|11|12[...]|30.

    Regards,

    dkone.
Sign In or Register to comment.