Hi,
i create a simple data item:
if ([Agent] = 'MAX') then (1000) else (0)
then i put it in the column (the rows shows the "Agents")
But the value "1000" are displayed as a title in the column and not as a value in the crosstab.
If i use "total (if ([Agent] = 'MAX') then (1000) else (0))" then the value are displayed in the crosstab, but, of course, not with the correct value.
Does anyone have an idea?
BR
D.
You have not given enough information, for example is the data source relational or dimensional, and what are you trying to show in your report? You are taking calculated measures (numbers) and placing them as edges on a crosstab, which makes absolutely no sense for a crosstab.
Open Report Studio help and read through the topics on relational versus dimensional reporting.
Quote from: dollipi on 18 Mar 2015 08:42:26 AM
Hi,
i create a simple data item:
if ([Agent] = 'MAX') then (1000) else (0)
then i put it in the column (the rows shows the "Agents")
But the value "1000" are displayed as a title in the column and not as a value in the crosstab.
If i use "total (if ([Agent] = 'MAX') then (1000) else (0))" then the value are displayed in the crosstab, but, of course, not with the correct value.
Does anyone have an idea?
BR
D.
Hi,
Assuming this is a relational package and you are defining this in a query calculation, set the Aggregate Function and Rollup Aggregate Function to 'Total' for this item and see if it delivers the result you desire.
Cheers!
MF.