Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
I need to Create a Dimension that Gives a Output In the following Way in a pivot Table:
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)
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
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
Hi,
Can you Plz Suggest .how to do it
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.
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.
Are you facing any issues to the approach I suggested?
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.