Hi,
It can work, the idea behind this is to create two inline fields that will hold the captions, and inside the expression you address them with if statement / peek.
For example
Load * INLINE [
TimeFrame
MTD
YTD
];
Load * INLINE [
Department
Sales
Distribution
];
The expression will be as follows
OB =
if(TimeFrame='MTD',
if(Department='Sales',sum(SalesMTD_OB ),sum(DistributionMTD_OB ),
if(Department='Sales',sum(SalesYTD_OB ),sum(DistributionYTD_OB ))
I hope it helps,
Eliran.
