Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
PFA work file and QVD...
I need to achieve output as per Expected report excel.
You can do this in visual cues tab. But you have to set some condition like < measure or > measure. Something like that.
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
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.