![]() Using a manual solution, I would also need to build into the formula additional logic to account for the rows being either collapsed or expanded. ![]() Up as Large or Small and can drill into the company detail. For example, in my final report, the companies are grouped (Large companies and Small companies). Unfortunately, by not being able to do this within the pivot table, the user encounters other issues such as the fact that the number of columnsĪnd rows will change with the selections made causing the formula column to constantly require to be moved.Īlso, the user would not being able to adequately utilize other functionality such as collapsing/expanding of row data. It appears you came to the same conclusions/workarounds I already reached. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |