Using the OVER function intersect

[Juan Vaca]

I was having trouble applying this function. on the explanation in the insert calculated column did supply much information.

I'm trying to match up the variables with the same location variables

the formula I have from the explanation is:

OVER (Intersect([Axis.]))

but I don't know how to apply it to these columns.

[Khushboo Rabadia]

If you try to plot Study in both Hoziontal and Vertical Axes of Cross table, you will always get a diagnol line. You cannot show them in the format seen in excel, as for A row, there is no row present for A and C intersection.

If this is not your actual use case, then please provide more description and valid sample example matching your use case.