Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Modified Pivot table report

Hi All,

I need to create shipment status report month wise but not understand how to add measure which is highlighted in green color.

PFA for expected output.

5 Replies
prma7799
Master III
Master III
Author

PFA work file and QVD...

I need to achieve output as per Expected report excel.

isingh30
Specialist
Specialist

You can do this in visual cues tab. But you have to set some condition like < measure or > measure. Something like that.

ajaysingh285
Contributor III
Contributor III

Hi P M,

Please find the attached file.

I have made as per your changes and you can add in expression for Jan,Feb... as per your analysis purpose.

Thanks,

Ajay

prma7799
Master III
Master III
Author

Hi Ajay,

This is not i am looking for ..

I need financial year also. I don't want create it manually.

PFA expected output.

Hi All , stalwar1 , tresesco,

Anyone can help me on this?

Thanks

tresesco
MVP
MVP

I am not sure I understand your requirement. If it's about getting fiscal year on top of the Months only, I am afraid that might not be feasible like that. Alternatively, you could create Fiscal Year in the script and then use Fiscal Year and Month as dimensions, and then pulling them to the columns is what usually should be done. However, since you have few more calculations which are independent of the financial year context, that possibility also looks grim to me. I can think of trying it with valuelist() as a chance (along with the year, month as dimension approach), but not sure if that could help or not here.

Or, else, try calculating the additional calculations in the script or as calculated dimension (not a good recommendation though). and then use the dimensions and pull across solution.