Daily Total in Pivot table

[#1]

I'm trying to have in my pivot table market coverage ratio. During basket analysis I have similar information to below:

• Date
• Product type
• Unit sold for this product
• Transaction count for his product for this day
• I need found information about total transaction for this day for all products

thought that will be easy and simple set analysis will solve  problem but it doesn't work.

I really don't want add this information to additional table in loading script.

[marcus_sommer · Accepted solution]

Try something like this. count(TOTAL <A> C)

- Marcus

[Anonymous]

Hi Piotr,

You are using Straight table, if you use this chart, use marcus_sommer‌ solution.

If you do it with Pivot Table, show subtotals.

I have attached one example with two options.

Regards!!

[er_mohit]

Try this

Aggr(NODISTINCT Count(C),A)

[#5]

I used Marcus formula and it's fine. Thank you for help.