|
Return to Newsletter Contents...
What's that Smell?
by: Aaron Zechman, BI Consultant, CRCP, MCSE
Oh man, what is that smell. It
really ranks. And speaking of
ranking it is not the same thing as ranking using Crystal Xcelsius.
You might also hear the term of ranking as a TOP N report.
Now for those who use Xcelsius, most of the work needs done in the Excel
spreadsheet and this is no exception.
Let us use the spreadsheet below while I explain the formulas to use.
Now let us take a look at the formulas being used before importing the document
into Xcelsius.
FIGURE 1: =RANK(C2,$C$2:$C$8)
FIGURE 2: =MATCH(G2,$A$2:$A$8,0)
FIGURE 3: =INDEX($B$2:$B$8,F2)
FIGURE 4: =INDEX($C$2:$C$8,F2)
Next we want to import the Excel document into our Xcelsius model and place a
combo box and a pie chart on the canvas.
Now let us configure the combo box to the following:
And then we need to configure the chart properties to the following:
Then
when we change our month, the new data is populated and the formulas change
accordingly. Voila!
You now have a report that stinks.
Go to Top |
Return to Newsletter Contents
|
