cancel
Showing results for 
Search instead for 
Did you mean: 

web intelligence crosstab

0 Kudos

Hi ,

I need to show my report in the following format

Measure1 Name - Measure1 Actuals - Measure1 Target - Sparkline for Fiscal Year

Measure2 Name - Measure2 Actuals - Measure2 Target - Sparkline for Fiscal Year

.

.

.

Measure14 Name - Measure14 Actuals - Measure14 Target - Sparkline for Fiscal Year

I am trying to convert month level data for an yera into spark line but i get sum(totals) at right extreme and another issue is its not one measure in a row completely so converting row data in spark line using ;SL_L_C_[start Column]_[end column} will not let me compare the trend of actual and target

can anyone suggest possible ways to acheive this in web intelligence

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member220897
Participant
0 Kudos

Are chance to convert it into a vertical table instead of crosstab? You would need to create 12 variables for each month, but sparkline rendering should get more straightforward.

0 Kudos

could you elaborate on the need for creating 12 variables for each month .

former_member220897
Participant
0 Kudos

Create variables like

[January Value] =  sum([Value]) where ([Month] = "January")

and so on

so that you have the freedom to place them where needed in a vertical table instead of a crosstab

0 Kudos

Hi Mahboob mohammed,

i cant give a sample data immediately but i can tell you how it should look in crosstab or any other tables in web intelligence

i have 12-14 measures

In the structure i gave measure actual and measure target are two different measures . Like if volume of goods is considered Actuals give goods sold in a perticular period and target gives the expected value to be sold

c1- c2- c3- c4

Volume c2:Actual 100Tons(in current year) C3:Target 110 Tons C$:sparkline or anything representing its value trend over 12 months in that year

c1,c2,c3,c4 are four columns in which i want data in above format

mhmohammed
Active Contributor
0 Kudos

Hi Naveen,

Some sample data and/or snapshot of how it looks in a chart can help us to help you better.

Thanks,

Mahboob Mohammed