When I group items in one pivot table, Excel will automatically perform the
same grouping in the rest of my pivot tables. How can I make each pivot
table independent of the others to be able to make different groups in each
pivot tables.
How do you mean, I have never had any problems grouping multiple pivot tables
differently?Regards,
Peo Sjoblom
quot;LynnFreequot; wrote:
gt; When I group items in one pivot table, Excel will automatically perform the
gt; same grouping in the rest of my pivot tables. How can I make each pivot
gt; table independent of the others to be able to make different groups in each
gt; pivot tables.
For all pivot tables based on the same pivot cache, the grouping is the
same. If you need different groups, you can base each pivot table on the
source data, instead of another pivot table.
LynnFree wrote:
gt; When I group items in one pivot table, Excel will automatically perform the
gt; same grouping in the rest of my pivot tables. How can I make each pivot
gt; table independent of the others to be able to make different groups in each
gt; pivot tables.--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
same grouping in the rest of my pivot tables. How can I make each pivot
table independent of the others to be able to make different groups in each
pivot tables.
How do you mean, I have never had any problems grouping multiple pivot tables
differently?Regards,
Peo Sjoblom
quot;LynnFreequot; wrote:
gt; When I group items in one pivot table, Excel will automatically perform the
gt; same grouping in the rest of my pivot tables. How can I make each pivot
gt; table independent of the others to be able to make different groups in each
gt; pivot tables.
For all pivot tables based on the same pivot cache, the grouping is the
same. If you need different groups, you can base each pivot table on the
source data, instead of another pivot table.
LynnFree wrote:
gt; When I group items in one pivot table, Excel will automatically perform the
gt; same grouping in the rest of my pivot tables. How can I make each pivot
gt; table independent of the others to be able to make different groups in each
gt; pivot tables.--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
文章標籤
全站熱搜
