Hi All,
Please see the attached image for the screenshot.
Category1 – Data Item Calculation is (A+C)/ (A+B+C+D+E+F)
Category2 – Data Item Calculation is (B+D+E+F)/ (A+B+C+D+E+F)
I want the calculation of category 1 data item be applied for only QTY column under Prior YTD and YTD Columns as shown above in the screen shot.
I dont want them to be calculated for Full revenue and Qty columns nested under YTD Change and YTD Growth.
What should my expression for data item category 1 should have, should I have a case to compare the column if its qty under Prior YTD and YTD.
Thanks,
Nithya
Hi,
The default content property when set to yes on a particular cell allows me to not write any data on the cell. But how do Iselect multiple cells and set default contents as yes. When I select multiple cells this property is not shown.
Thanks,
Nithya