Very useful video. I was getting errors trying to group my text fields and finally figured out that grouping does not work if you add the pivot table to the data model (at least for me). I usually check the box to "add to data model" so I can access the Count Distinct stat.
@leorc564
Жыл бұрын
Muy bueno Chris!, thank you!
@ChrisMenardTraining
Жыл бұрын
Glad to help.
@nickvanderhorst7226
5 ай бұрын
Thanks for this informative video! One question, how can you remove a single entry from a group without having to ungroup the entire pivot table? For instance if i want to omit 'Honda' from the Japan group, without affecting the other car brands, how can i do this? If i select Honda and right click ungroup, then my entire pivot table gets ungrouped. Is there a way to prevent this?
@muhammadpoonawala3890
Жыл бұрын
Sir, how to summarize data in pivot table where my requirements is the last day of every month ?
Пікірлер: 7