Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there any way to use Set Analysis in a Dimension field of a Pivot chart?

Is there any way to use Set Analysis in a Dimension field of a Pivot chart?

2 Replies
Not applicable
Author

also for me this question are very interesting.

Anyone knows something about this problem?


Thanks!

johnw
Champion III
Champion III

You can.  To use set analysis, you need an aggregation function like sum() or only().  To use an aggregation function like that in a dimension, you need to use an aggr().  So as a quick example that I just did in one of my applications to make sure I wasn't mistaken:

=aggr(only({<"Sheet / Tin"={'SHEET'}>} "Bill Payer Name"),"Bill Payer Name")

It's a bit of a silly example, but it demonstrates that you can indeed use set analysis in a dimension in a pivot table.