Grand Total to capture and divide by

Topic

New Reply

Hi everyone!

Can you please, help me with dilemma.

I am replicating Report in Access that was previously done in Crystal.
Crystal has ability to calculate totals by row and by column.
I am not sure Access has the same, so here is the problem – last summary page data looks like following:

ID_______Prod1___Prod2___Prod3___Total
11_________5_______6_______7______18
12_________6_______6_______7______19
13_________5_______7_______8______20

I have calculated totals:

Total_____16______19______22__GT:__57

*************************************

The problem is now I need to have percentage of

Prod1/Total of Prod1 – 5/16, Prod2/Total of Prod2 – 6/16 etc
also
Prod1/GT – 5/57, Prod/GT – 6/57 etc

for each Prod and ID. I am trying SUBs etc. but I can’t figure out how to keep Grand Total to divide by.

Thanks

Reply | Quote

Replies

The problem is now I need to have percentage of

Prod1/Total of Prod1 – 5/16, Prod2/Total of Prod2 – 6/16 etc
also
Prod1/GT – 5/57, Prod/GT – 6/57 etc

for each Prod and ID. I am trying SUBs etc. but I can’t figure out how to keep Grand Total to divide by.

In attachment a database sample. See in query SumByRow if you have all the values you want.

Reply | Quote

Francois!
It seems like it is all I need! I will have to take a beter look but I see numbers I need.

Thanks so much for your time and help and have a great day!

Reply | Quote