Create A Dimension in a Pivot Table -Month,YTD,Fiscal Year

[QVUser1]

Hi Folks ,

 I need to Create a Dimension that Gives a Output In the following Way in a pivot Table:

[Kushal_Chawda]

Create inline table

Dim:
load * inline [
Dim
1
2
3 ];

Create Pivot table
Diemsnion:
1) Country
2) Region
3) pick(Dim,Month,'YTD','FiscalYear')

Expression: (assuming it is sum(sales)
=Pick(Dim,
sum(Sales),
YTD Expression for Sales,
Fisacal Year Expression for sales)

[QVUser1]

Thanks For the Reply ..

Any chance of deriving field in the back end . like field Should contain:

Dimension:

Jan -2020

Feb-2020

Mar-2020

Apr -2020

YTD

Fiscal Year

[Kushal_Chawda]

You can do it but I would not suggest as it will make things more complicated. What I have suggested is the best way you can handle this requirement

[QVUser1]

Hi,

Can you Plz Suggest .how to do it

[Kushal_Chawda]

Is there any specific reason you want to do it in script? As I said It will be more complicated and not advisable to do that.  

[QVUser1]

The reason is here i am already using Inline dimension and writing the expression . so i dragged the column of month on top of pivot table . if i have ytd also in same column it will be easy for me.

[Kushal_Chawda]

Are you facing any issues to the approach I suggested?

[QVUser1]

Yes ... i need it in master calendar could plz help on this .

Desired Output:  Jan20  Feb20  Mar20  Apr20  May20 Jun20 Jul20   YTD  

I need this Desired in  single column to drag it on the top for Pivot Table.