Hi All,
I have below requirement please help me on this. It's very urgent requirement. I want it in Cross tab table.
I'm getting data as first table. But I want to as 2nd table. Please help me
Thanks
Riaz
Anybody here to help on this...
Hi Riaz,
The columns are based on groups so you will have to make a formula that will separate your records into two different categories. Now you can use that formula as your column.
Good luck,
Brian
Hi Brian Dong,
Thanks for the response. Depends on what do I need to group. These are all measures. I don't have other column. Is there a way to group measures using measures.
Thanks
Riaz
Hi Riaz,
How are the measures supposed to be categorized?
Do you have a 'real' data sample please?
-Abhilash
Hi Riaz,
Your questions are not detailed enough. We need more specific details of how you would like your measures grouped or more information on how you data is structured.
Can you use measures to group? Yes. The question you should be asking is how can you group your measures based on what type of scenario. We can't answer your questions without details.
In the second screenshot, how would you like to see the data grouped?
What are the rules to have the different group?
Unfortunately, you screenshots just show us numbers with no real help.
Thanks,
Brian