This content has been marked as final. Show 2 replies
With your cube datasource, are you able to pivot all the numerical columns into two on the DataSource tab?
If so, then you can simply use:
IF [Pivot field values]=1 THEN [Pivot field names] END
Otherwise, will need to think further.
Book3b.twbx 347.6 KB