Total sum of sales with selections

[jorgen_santberg]

Hi all,

I have a a straight table with the following dimensions:

- Customer

- Type

      - Brand

            - Article

And the expression Sum(Sales)

Where brand is a subcategory of type and article is a subcategory of brand.

What I need is the total sales per type per customer. That can be done by 

Sum(Total <Type,Customer> Sales)

But if I select 1 article  it gives only the sales of this article.

When I use Sum({<Article>} Total <Type,Customer> Sales) it gives me the right sum of sales after selecting an article but

it still shows all articles  (with sales 0 as a result). I want only the selected article to be shown.

Any one got the solution for this? Thanks!

[justISO · Accepted solution]

Hi, I suggest to use aggregation by type and customer and ignore selection of article, so something like this:

aggr(nodistinct sum({<Article=>} Sales), Type,Customer)

[jorgen_santberg]

Yes, works perfect. Many thanks!