Hi, I have two question in one:1. I'm trying to add a variance column in
a Pivot in BI Viewer for amounts that are split by 2 scenario's, actuals
and budget. What is the most practical way to do this? I thought I would
add a variance in my cube view ...
Hi, in the getting started with BI viewer I see they make use of a date
field, which enables you to drill down to quarters/months etc. How do
you create such a field (I guess I have to something with the time
dimension which contains my years and mon...
Perfect, that's it. Still getting used to the syntax! Many thanks. I've
a last question regarding this BI project if I may. I notice that in a
pivot I can only sort rows/columns when in the BI designer, but the user
cannot when viewing the dashboard....
Hi Sai,thank you this seems like a very suitable solution as we don't
have that much different scenario's in use. So I'm trying to do this,
step 2 and 3 I think are ok. Step 1 and 4 is actually one step am I
right? When I try to create the measure I ...
Sorry, let me explain myself. You pointed me out in order to create an
actual / budget and variance column in a pivot, that I should create
calculated fields:Actual, Expression = Iif([Scenario] = 'Actual',
[Amount], 0)Budget, Expression = Iif([Scenar...