Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
in a table accumulated values should be calculated. The column Proj contains accumulated values. How can column Test calculated?
The following formula have no function (Column (1)-Column (2))
Regards Stefan
Or change your second expression to be this
RangeSum(Above(Proj, 0, RowNo()))
with no accumulation selected
May be this
Column(1)-RangeSum(Above(Proj, 0, RowNo()))
Use this
sum(Prod)-sum(Proj)
Or change your second expression to be this
RangeSum(Above(Proj, 0, RowNo()))
with no accumulation selected
Many thank. How can I create a 100% stacked bar chart?
What is the logic? Can you share the expected percentage in Excel file?