4 Replies Latest reply on Apr 17, 2018 5:16 AM by Patrick Weber

# sub total of a category next to total column

Hi guys,

on my attached workbook example I have a worksheet where you'll see all customers, total sales and the amount of invoices which have the type 'webshop'.

How is it possible to show only the sales for webshop next to my totals?

Is there an easy solution?

This is what I would expect:

customer
saleswebshop sales
amount_webshop sales
Baker47048422008
Doe55758137855
Jones57380160572
Smith7872772332

Thanks for any tips.

• ###### 1. Re: sub total of a category next to total column

Hi Patrik,

if [Note]='webshop' then [Sales] END

drag this into measure values,

• ###### 2. Re: sub total of a category next to total column

Hi Rajan,

I have some logic issue plz solve this one it is urgent

thanks,

Veeru.

• ###### 3. Re: sub total of a category next to total column

Ok this is working if sales is not already an aggregation. But how to solve this problem if sales is an aggregation? In this updated attachement there you'll find sales2. I tried followed calculation called calc IF [Note]='Webshop' then {fixed [Customer]: sum([sales2])} END but the result is wrong.

• ###### 4. Re: sub total of a category next to total column

Thanks, now I got it. If there is an aggregate you can use this: sum( IF [Note]='Webshop' then ([sales2]) END)