BusinessObjects Board

Negative values along with Positive values in a Pie Chart

​Hi,
We are converting existing Xcelsius dashboards, which shows negative along with positive like Total Income is positive and Total Expenses is negative.
Environment :
BI 4.2 SP04 Patch 01
Lumira designer 2.0
Query based on Universe (unx)
Database: Oracle

Dimension object : Category
Measure : Amount ( note : amount can be in negative or positive for a category)
1: How to show negative values along with positive values in a pie chart.

2: If can not show as negative value along with positive in a pie chart , then how would I convert it to positive in lumira designer itself not in universe and assign it to pie chart)
3: Can I map values (dimension and measure) to pie chart using script ?

Please help …
Regards
Sahil


sahil4bousers (BOB member since 2011-11-02)