amitchandak
Super User
5 years agoDynamic Segmentation/ Bucketing/ Binning
Dynamic Segmentation/ Bucketing/ Binning
Created an independent bucket Table.
Create measures that take advantage of those buckets
Actual Measure
Margin % = DIVIDE([Margin],[Sales])...
Anonymous
1 year agoNot applicable
Hi Amit,
I am facing a different issue where the bins should be calculated based on the dynamic Min & Max (dynamic range of data based on category selection).
My data is like this:
Category A sales ranges from -300 to 400 ( need to create 20 bins in this range when I select 'A' in the category slicer;
Category B sales ranges from 200 to 800 ( need to create 20 bins in this range when I select 'B' in the category slicer; and so on..
Currently bins are creating based on the total range -300 to 800 which is not required.
Is there any workaround to achieve this?
Appreciate your inputs..Thanks in advance..