Skip navigation

Step:1

Create one [Show Selection] and add list as Actual and Target.

agg measure.png

 

Step:2

Create calculation as

case [Target parameter]

when "Actual" then [Actual Value]

when "Target" then [Target Value]

end

 

Step:3

Create 2nd calculation as

case [Actual parameter]

when "Actual" then [Actual Qty]

when "Target" then [Target Qty]

end

 

Step:4

Drag this two calculations into row.

 

Step:5

Show parameter and select Actual or target.

 

Note:

if you want to show multi measure in single axis

Drag measure name into column and measure value into row.

Remove other measure and add only calculated data.

Step:1

Create parameter [Measure Parameter] list as sales, profit and Unit Price

 

measure para.png

 

Step:2

Create parameter [Agg Measure Parameter] list as Sum and Avg

 

agg measure.png

 

Step:3

Create calculation as follows [Measure Agg Calc]


IF [Measure Parameter] ="Sales" and [Agg Measure Parameter] ="SUM" then SUM([Sales])

ELSEIF [Measure Parameter] ="Profit" and [Agg Measure Parameter] ="SUM" then SUM([Profit])

ELSEIF [Measure Parameter] ="Unit Price" and [Agg Measure Parameter] ="SUM" then SUM([Unit Price])

ELSEIF  [Measure Parameter] ="Sales" and  [Agg Measure Parameter] =”Avg” then AVG([Sales])

ELSEIF [Display Selection] ="Profit" and [Agg Measure Parameter] ="Avg" then AVG([Profit])

ELSEIF [Measure Parameter] ="Unit Price" and [Agg Measure Parameter] ="Avg" then AVG([Unit Price])

END


Step:4

Drag this [Measure Agg Calc] into column and drag any of dimensions into row


Step:5

Show Parameter control and select Kpis.

Step:1

Create parameter [Measure Parameter] list as Sales, Profit and Unit Price

measure para.png

Step:2

Create calculation as follows [Measure Calc]

case [Measure Parameter]

when "Sales" then [Sales]

when "Profit" then [Profit]

when "Unit Price" then [Unit Price]

end


Step:3

Drag this [Measure Calc] into coloumn and drag any of dimensions into row


Step:4

Show Parameter control and select Kpis.

By using Index( ) in calculated filed and drag that calculated field in rows shelf we can achieve this.Please find the attached twbx.I hope this solves your problem

 

Step1: Create calc field called index ie index( )

 

Step2: Drag the customer name and calc field index into row shelf.

 

Right click customer name descending and sort via field [sales]

 

Step3: create [Top N] parameter with integer data type

 

Step 4:Create calc field called top10? Title Top 10 calculations – Top10?

 

if [Index]<=[Top N] THEN "Top N"  ELSE IF [Index]>=SIZE()-[Top N]

THEN  "Bottom n"  else “Others” end end

 

Drag calculation field Top 10? Into filter then select top n and bottom n.

 

Drag the new calculation into row.

 

show parameter control and type 10,20 etc