Hi everybody !
I' m doing a small report which aggregate the revenue of different category of people. The category is managed with a Hierarchy.
A row of the dataset ( an output of a query ) is composed by
OFFICE NAME, SURNAME, CODE CATEGORY A, CODE CATEGORY B, REVENUE
Category B is a "subset" of Category A.
My problem is :
if I do a hierarchy with SURNAME, CODE CATEGORY A, CODE CATEGORY B, REVENUE the report is good.
if I do a hierarchy with Office Name, CODE CATEGORY A, CODE CATEGORY B, REVENUE the report is worng and on the report I receive an error. It's translation is : Impossible to find a column referenced from the query.
I attached a screen-shot .
Can you suggest me how avoid this problem ?
Thanks a lot in advance,
regards
... View more