Can you please help me with the rank formula syntax? Because the values on the charts are added based on unique supplier/parts/dealer number and day groups.
formula is like= for each supplier number, count (>14)/ Grand total (>14) + count (8-14)/ Grand total (8-14) + count (2-7)/ Grand total (2-7) + count (0-1)/ Grand total (0-1)
Sorry for the delay. I am attaching the link herehttps://drive.google.com/open?id=0B3RVPzvmX8RMa3FiTXVodXhyMDVyMVExNGczZG83MFpfcmUw. What I need is, instead of the stacked bar charts showing all the parts/supplier/dealer numbers, I just want top 10 of them to show based on the Percentage Grand total Count of Customer Order ID. This same parameter: %GT Count of System_CustomerReferenceOrderID is used as a value in all the stacked charts.
You can download the files from here. https://drive.google.com/file/d/1VHreQui0vYx-qhM48QgQZBNEoO9DomGt/view?usp=sharing
I am using year based slicer and expected result would be Last 5 year sales based on Year slicer selected value. Since I am using tabular model so i have limitation ; i can't use some date like SELECTEDVALUE, etc in my solution.
Please help me