Conditional Variables

[PETEHO]

I have some users who want some extra info for a one off report.Basically they want to report on a field from the universe which is ytdspend. They want this column 7 times but the YTD amount is dependant on an account code.

How do I set each column up to report differently for the same field in effect. Or do I have to create measures in the universe.

Thanks for you time

 

[blom0344]

These requirements are usually met with constructions like :

SUM(CASE WHEN condition1 THEN measure1 ELSE 0 END)

In this case use the accountcode for the condition and you can retrieve multiple conditoned measures that are pre-built in the universe.

Ties Blom

 

[PAULSGS]

You could create 6 or 7 variables in your report based upon a single retrieved column and use these variables in your report

 

[skrandel]

YOu could do this with report variables, but your users will not be happy as it will take much longer to open the report and to navigate between tabs.

Fix this as far upstream as you can.

Steve Krandel
Symantec