Skip to Content
0

web intelligence crosstab

Nov 22, 2016 at 02:55 PM

130

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Mahboob Mohammed Nov 22, 2016 at 03:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
naveen raju Nov 23, 2016 at 09:05 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Andrey Surinov
Nov 23, 2016 at 12:01 PM
0

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.

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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