How to create cross tab report like Pivot table

Kamya Pamnani

Hi,

I want to create cross tab report like Pivot table but without using Pivot app. Please suggest how to do that. I want to show 1 column in the left and other column on the top with sum or count of values. I tried to use Report but in Report it comes in vertical report and not like cross tab format.

Please suggest on how to do

Genevieve P.

Hi @Kamya Pamnani

What data is it that you're looking to collect? You could use a COUNTIFS or SUMIFS function to create your calculations and use cross-sheet references to look into your source sheet, returning a value based on what's in your column to the left.

If you need help with the formulas, it would be useful to see a screen capture of your source sheet and an explanation of your end-goal, but please block out sensitive data.

Thanks!

Genevieve