Hi! Crosstab return "no data available" when i add slicer in main query. Crosstab connected to query reference. Without this slicer Crosstab returns correct data. And if Crosstab conected to main query (with slicer) returns correct data. Please help me to understand what may be wrong in this situation.
it start working if add member that used in slicer in main query to Crosstab.