I am facing a problem here.First please go through my attachment.Here the 'Total Number' row contains the absolute number, but the row number 3 onwards contains the percentage data.These both data are to be shown in a same field at a time.
How this kind of data representation can be possible?
Please answer this problem this is urgent for my job.
Thank you Amars for your reply. But this woiuld not solve the purpose as the data is not maintained in the excell file it is rather maintained in the text format and all the data fetched from these txt file. Therefore I have no chance to modify the data within the excell as you have done.
Please show me any other way out regarding this problem.
The logic doesn't lies within the Excel sheet. It doesn't matter if the data comes from an excel or Text file. If you see within the application I have kept all values as one expression and within the pivot I just have dragged the dimension and expressions. If possible share a sample of your application.
