Forum Discussion
Solved
Index depending on column value
Hi, I have this situation: I created a conditional column that indexed my value. My problem is that I want this count restart depends on the week value and more i want to index my value...
From your table
you group rows by week and by count (in order to manage situation of parity)
hten you group by week
then you order descending your column count inside your groups
at this point you add and index column
at this point you first expand Custom
you obtain this
Finally you expand AllRows.1
remove unnecessary column and that's done
serpiva64 just to close the question.
I want to represent this in table. I wanted to insert the data you found in such way:
How can I do that in a table?
Thanks
Hi,
You can achieve something like this from your previous
Add acolumn with W-1
Merge your query on itself
Expand
Change type then add difference column
change type
then you can create your matrix