I'm a newbie to the form, so thank you in advance for your responses!
I've used spreadsheets for a long time (remember wth spreadsheets were done in VisiCalc?), but am perplexed by a seemingly routine matter.
I would like to create a pivot table that summarizes my variables and shows each variable on a single row. The trick is I do not want to next anything - I just want the total (sum) of the variable or the variable itself on each row.
For example, I have 100 rows with a customer record on each. I have 10 columns with data about the customer in each.
Three of the columns are Has Hat (Y/N), Has Coat (Y/N), and Has Scarf (Y/N), Previous Orders (single number)
My objective is to show the following:
Previous Orders Grouped
1 2-3 4-5 6+
Has Hat (=Y only)
Has Coat (=Y only)
Has Scarf (=Y only)
I do not want to nest the coats and scarfs under hats. They all need to be on their separate rows.
Formatting does not seem to work, and neither do the options.
Any thoughts without using macros (sorry, not interested in macros!)?
Thank you!
I've used spreadsheets for a long time (remember wth spreadsheets were done in VisiCalc?), but am perplexed by a seemingly routine matter.
I would like to create a pivot table that summarizes my variables and shows each variable on a single row. The trick is I do not want to next anything - I just want the total (sum) of the variable or the variable itself on each row.
For example, I have 100 rows with a customer record on each. I have 10 columns with data about the customer in each.
Three of the columns are Has Hat (Y/N), Has Coat (Y/N), and Has Scarf (Y/N), Previous Orders (single number)
My objective is to show the following:
Previous Orders Grouped
1 2-3 4-5 6+
Has Hat (=Y only)
Has Coat (=Y only)
Has Scarf (=Y only)
I do not want to nest the coats and scarfs under hats. They all need to be on their separate rows.
Formatting does not seem to work, and neither do the options.
Any thoughts without using macros (sorry, not interested in macros!)?
Thank you!