14 Replies Latest reply: Jun 15, 2011 10:04 AM by Dennis Hoogenboom RSS

    set analysis -- clarification

       Hi All,


            I am doing a Dashboard where I have to show a pivot table which has the data about the Plan Cost and Actual cost.Actual cost is working fine in the Table.I have a problem with the set analysis expression.


      This is the onI have used in the chart


       

      <SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;">

      count({<Month_Cost = {'June'},Month= {'June 2011'},[Travel Mode] = {'Flight'}>}Cost_Targets) .I have two months in the table.




      Month is the field present in the fact table.Month_cost is the field which is connected to the fact table using Region field.


       

      <SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;">


       

      <SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a" mcestyle="font-size: 8pt; color: #5a005a;">


       

      <SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a; FONT-FAMILY: " mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a; FONT-FAMILY: " mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a; FONT-FAMILY: " mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a; FONT-FAMILY: " mcestyle="font-size: 8pt; color: #5a005a;"><SPAN style="FONT-SIZE: 8pt; COLOR: #5a005a; FONT-FAMILY: " mcestyle="font-size: 8pt; color: #5a005a;">I have used the