Hi, I have now tried to work with estimates, the problem is that there are no wide shrink buttons And my report consists of many lines. Is there a ...
Is there a guide on how to work with set based? And how do you work with MDX? Where did you add the calculations ??
Velouria, your solution with the SET looks great The thing is, I need more lines of calculations I would like a brief instruction - how do I set up a ...
Thanks for the response, It is still not clear to me how to use with GetPivotData Attached is a sample file Where the years and months are in the colu...
The GetPivotData Allows me a formula outside of the pivot and if I make changes to the pivot structure it disappears. The CUBE function looks amazin...
I started working on DAX in Power Pivot My problem now is that I need the percentages only for the final total and not for all the lines (As in the a...
Unable to upload file Then I will attach a picture
I wrote here now a long function - In the yellow cell in the attachment Is there a way to write it shorter? Is there a possibility for Sukkot - do not...
Thank you Minda for the answer !! The formula still does not work for me I got 17 hours - it is not clear to me which cells he calculated Attaches the...
According to the example - the cells that Excel needs to sum up are F16: F18 I also need to summarize a line before Yom Kippur And also a line after Y...