Pivot view calculation going wrong

[Deleted User]

Not sure if I'm speaking chinese or some dead language but once more:

a) If you let the DIMENSION do the splitting of the MEASURE then it will work. And not use any weird formulae.

b) If you use FILTER - the function - you don't NEED any filters - filters as in analysis filters.

tl;dr - this will work on any SA:

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">

   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;A - Sample Sales&quot;">

      <saw:columns>

         <saw:column xsi:type="saw:regularColumn" columnID="c4ba977d3126195f9">

            <saw:columnFormula>

               <sawx:expr xsi:type="sawx:sqlExpression">"Time"."T05 Per Name Year"</sawx:expr></saw:columnFormula></saw:column>

         <saw:column xsi:type="saw:regularColumn" columnID="cca2abe630db82f67">

            <saw:columnFormula>

               <sawx:expr xsi:type="sawx:sqlExpression">"Products"."P4  Brand"</sawx:expr></saw:columnFormula></saw:column>

         <saw:column xsi:type="saw:regularColumn" columnID="cac797b0cd4bd6ea0">

            <saw:columnFormula>

               <sawx:expr xsi:type="sawx:sqlExpression">FILTER("Base Facts"."1- Revenue" using "Time"."T05 Per Name Year"=2014)</sawx:expr></saw:columnFormula>

            <saw:tableHeading>

               <saw:caption fmt="text">

                  <saw:text>Base Facts</saw:text></saw:caption></saw:tableHeading>

            <saw:columnHeading>

               <saw:caption fmt="text">

                  <saw:text>2014 Revenue</saw:text></saw:caption></saw:columnHeading></saw:column></saw:columns></saw:criteria>

   <saw:views currentView="0">

      <saw:view xsi:type="saw:compoundView" name="compoundView!1">

         <saw:cvTable>

            <saw:cvRow>

               <saw:cvCell viewName="titleView!1"/></saw:cvRow>

            <saw:cvRow>

               <saw:cvCell viewName="tableView!1"/></saw:cvRow></saw:cvTable></saw:view>

      <saw:view xsi:type="saw:titleView" name="titleView!1"/>

      <saw:view xsi:type="saw:tableView" name="tableView!1" scrollingEnabled="true">

         <saw:edges>

            <saw:edge axis="page" showColumnHeader="true"/>

            <saw:edge axis="section"/>

            <saw:edge axis="row" showColumnHeader="true">

               <saw:edgeLayers>

                  <saw:edgeLayer type="column" columnID="c4ba977d3126195f9"/>

                  <saw:edgeLayer type="column" columnID="cca2abe630db82f67"/>

                  <saw:edgeLayer type="column" columnID="cac797b0cd4bd6ea0"/></saw:edgeLayers></saw:edge>

            <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges></saw:view></saw:views></saw:report>