Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have industry names in dimension & i am totaling no. of email ids that i have against each industry. Now i want to arrange count of email ids in descending order so that industry with maximum email ids should come on the top
Go to Sort tab and write below in Expression .....
COUNT(Distinct EmailID)
Select Descending Order....
Also, change appropriate FieldName
Go to Sort tab and write below in Expression .....
COUNT(Distinct EmailID)
Select Descending Order....
Also, change appropriate FieldName
thank you very much ... this helped.
Now i am adding dates also as a dimension. what i now want is industry wise, date wise, count of email ids in descending order. what should i do?
Provide Sample Data...
Please note that Interactive Sorting is not possible in Pivot Table... You need to sort by First Dimension then Next ....
Industry | Dateopen | 18-08-14 | 20-08-14 | 21-08-14 | 25-08-14 | 01-09-14 |
Total | 343 | 46 | 67 | 279 | 581 | |
BPO /KPO | 91 | 5 | 35 | 87 | 75 | |
RETAIL | 90 | 20 | 2 | 70 | 76 | |
Services | - | - | - | - | 94 | |
Information Technology | - | - | - | - | 71 | |
MANUFACTURING | 34 | 9 | 5 | 31 | 21 | |
OEM | 39 | 1 | 8 | 22 | 21 |
Many thanks Manish... its resolved
Kindly close the thread by selecting correct/helpful answer
i dont know how to close a thread... i am new to this forum.. please guide