Basic totals? One row pivot table or show only aggregate totals?

[roattw]

Im looking to generate a simple TOTAL count of attendees for 5 events.  Deceptively hard in Caspio reports.

I dont need all the data that comprises those totals.    We are just counting Yes/No entries for people attending various events.  But,

1) data report wont show aggregates/totals without the data that makes up those totals, and
2) pivot tables wont do a single row 

I need this:

 

But all I can get is this:

 

Thanks everyone

[cheonsa]

Hi @roattw,

Actually, you can use Pivot table to achieve your desired Report. 

You can use Totals and Aggregation under values and add custom formula. 

This will be the result

Cheers!

-LittleMsGinger

[roattw]

OMG!  Thank you LittleMissGinger!  In all the videos I watched they never noted that you dont have to assign a Column and Row value.  Ugh.  Working as expected now.  Its always the little misses for me ;^)

[roattw]

Going back a little.  What if you wanted to apply a sort to this by date, splitting them into rows.  Could that be done with an adjustment  GROP to SQL statement?

                                 Event 1                 Event 2               Event 3

Date 1                      5                               6                                 2

Date 1                      12                             9                                 6

 

[cheonsa]

On 3/22/2022 at 7:17 PM, roattw said:

Going back a little.  What if you wanted to apply a sort to this by date, splitting them into rows.  Could that be done with an adjustment  GROP to SQL statement?

                                 Event 1                 Event 2               Event 3

Date 1                      5                               6                                 2

Date 1                      12                             9                                 6

 

Hello @roattw,

You may try to add the Date field under Rows. Then, just a little adjustment on the formula.