I have created a pivot table having the dimension Site Name and the measures-Amount,Qty,Profit.I have created the following expressions for MTD,QTD and YTD.But I want the table as same as the format of the attached excel.If I introduce a mapping table for the same,the expressions are repeated for MTD,QTD,YTD.Please help me out.
Thanks for your Quick response.Are U Loading an excel inside the QVW?Can U share the same?But my amount,Qty,Profit are generated from the Fact tables?How are U specifying Type as MTD,YTD,QTD please explain.
yeah I just grouped (created a new field Type) them as per the output report in the xls itself. if you have a sample qvw then I can check how your actual data load looks like. I think you might have a transaction table that might have data at daily or monthly level and from which you might have define the time dimensions like Month, Qtr and Year.