Hi
I am attaching this file, I have done some countifs analysis in the analysis tab and tried
to do the same with Pivot table in under pivot tab.
Question1: Is there any better way of doing countifs instead of writing these long codes.
Question 2. When grouping the amount finance from 0-75k, 75k-150k , it doesn't allow to
group from 150-300k as if I do that it changes the whole grouping, please advise if there
is any way to group in to 04 categories as 0-75k, 75-150k, 150-300k and 300k-500k.
Question3: when I select different slicers the column width always changes , is it possible to fix the pivot table columns width as fixed.
please advise if its possible.
I am attaching this file, I have done some countifs analysis in the analysis tab and tried
to do the same with Pivot table in under pivot tab.
Question1: Is there any better way of doing countifs instead of writing these long codes.
Question 2. When grouping the amount finance from 0-75k, 75k-150k , it doesn't allow to
group from 150-300k as if I do that it changes the whole grouping, please advise if there
is any way to group in to 04 categories as 0-75k, 75-150k, 150-300k and 300k-500k.
Question3: when I select different slicers the column width always changes , is it possible to fix the pivot table columns width as fixed.
please advise if its possible.
