I’m trying out the input columns and have a use case where I want to have the input column within a pivot.
So for example I have month pivoted across the top and I have the dimension attributes on the left. Within each month I have days and rate and a forecast amount (days * rate). I wanted to add a days override input column that I can tie into a revised forecast column (override days * rate) which I have and works if the data is unpivoted, but as soon as I pivot the year month, the override days sits outside of the pivoted data.
Is this functionality with input columns supported or only in an unpivoted view?
E.g.
Override works unpivoted, but not really useful in a long list:
When pivoted on month, you can see the override sits outside of the pivot and the rows then get split because the override has been entered at the month level
