Hi Andy, when I open up the Compute Using... dialog box, I also see Pane options. A pane is just a window, so if I choose Pane (down) I should have the same result as choosing Specific Dimension / Sub-Category. However, what I get is just 1's everywhere. Could you please explain why? Thanks.
Specific dimensions allows the table calc to compute exactly as you specify. The pane options will change the values if you move dimensions in the view.
If current month is not completed then I have to consider data up to previous month only. If last day of the current month is end of the month then I should consider data upto current month. Can anyone help me with the calculation
Is there a way I can create a parameter to select the top N sub-category by sales for each state? Please help. Thank you
Hi Andy, when I open up the Compute Using... dialog box, I also see Pane options. A pane is just a window, so if I choose Pane (down) I should have the same result as choosing Specific Dimension / Sub-Category. However, what I get is just 1's everywhere. Could you please explain why? Thanks.
Specific dimensions allows the table calc to compute exactly as you specify. The pane options will change the values if you move dimensions in the view.
easy and to the point as always.. Thanks Andy
As usual very handy trick Andy !!
Very cool, thanks Andy!
you are a life saver. thank you so much for this.
Glad it helped!
Easy and effective..Thanks Andy!!!
If current month is not completed then I have to consider data up to previous month only. If last day of the current month is end of the month then I should consider data upto current month. Can anyone help me with the calculation
Good question for the forums. Ask over there please. This channel isn't designed for that kind of help.
@@vizwiz Can you rephrase @Govardhan Bola's question, Andy? Seems like a good practice for me, but I don't understand his question. Thanks.
how would I find the worst selling item? (smallest)
In the rank calculation, set it to ascending. By default it’s descending.
Where can I get the data set ?
It's superstore.
@@vizwiz Thank you
Super Cool