Group on 2nd Dimension in Data table

[#1]

Hi,

Can anyone help me in grouping data on 2nd dimension to calculate contribution %..

I am not able to calculate contribution of "Category 1 & month April"  in Apr month in a Pivot table.

When I put Total function in expression, I get contribution of "Category 1" in entire data table.

I am able to do it on excel but not able to do on QV, please help me with Expression or any other way of doing it.

My table looks like - I have attached excel file also where I am able to calculate the contribution.

Month	Category	Count
Apr	Category 1	4
Apr	Category 2	16
Apr	Category 3	13
Apr	Category 4	40
Apr	Category 5	6
Apr	Category 6	9
Apr	Category 7	12
May	Category 1	25
May	Category 2	63
May	Category 3	88
May	Category 4	110
May	Category 5	4
May	Category 6	73
May	Category 7	29
Jun	Category 1	11
Jun	Category 2	2
Jun	Category 3	137
Jun	Category 4	282
Jun	Category 5	354
Jun	Category 6	17
Jun	Category 7	219

Thanks,

Narsingh

[joshabbott]

Try this:

=sum(Count)/sum(TOTAL <Month> Count)

Attaching sample

[ecolomer]

See the fila attached

[#4]

Thanks Josh & Enrique for you prompt responses!!

Sorry that I couldn't explain my problem correctly.

Excel which I sent, that is output of a QV pivot, In my data I have dates instead of Month and Categories are given but not count.

I am not able to use this formula because of dates and I want this pivot "Month wise".

Please help... Sample data is attached

Thanks,

Narsingh

[joshabbott]

Instead of the sum I supplied above, just use a 'Count'

=Count(Category)/count(Total <Category> Category)

[joshabbott · Accepted solution]

example attached

[#7]

Thanks Josh, Now I able to calculate!!!

This helped a lot

[ecolomer]

See the new file attached ...