Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends How are you,
I have to build a table data that compares Real Sales vs Forecast. This table has a particularity as you can see in the image below.
The first column is the Sales Period and the First Field is the Forecast Period. When The Sales Period and The forecast Period are the same the value that i have to set is the Sum(RealSales) (Numbers in bold format), the other values are the Forecast.
Can anybody help me?
Best Regards
Should be doable with an expression with an if statement: =if( [Sales Period] = [Forecast Period], sum(RealSales), sum(Forecast)). Then click on the + in front of the expression, select Text format and enter an expression in the Definition field like =if( [Sales Period] = [Forecast Period], '<b>')